Skip to Content
Former Member
Aug 31, 2007 at 04:36 PM

Query not using BIA



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,