I have a query that runs against AR cube, which has about 22million data. Without BIA, when I run the query against this cube, it takes about 30mins out of which DM read time is 660sec.
When I ran the same query with BIA, it took almost same time with DM read time 570sec.
I believe, even though there are too many formula's in the query DM read time should not be affected as we have BIA for this.
I even tried to recreate BIA index for that cube with no luck.Interesting thing is when I check RSDDSTAT_DM table to see if the query is using BIA or not, I see its not using. Even with BIA, its still accessing the cube. I check in RSDDBIAMON2 to see if query is turned off for this cube, but its not.
So I dont understand even after BIA active for this cube, why query is not using BIA? Any thoughts really appreciated.
Thanks in advance,