Skip to Content
Former Member
Apr 27, 2005 at 11:06 PM

Query on BCS virtual cube is not using the aggregates on BCS basic cube


Hi all,

I have BCS Virtual cube which is linked to BCS Basic cube. I built aggregates on BCS Basic cube.

I created simple query on BCS basic cube and ran in debug mode of rsrt, it showed the aggregates on bcs basic cube. But when I created the same query on BCS vitual cube and ran it rsrt debug mode the query did not show any aggregates, that was strange.

So My questions is whether query built on virtual bcs can utilize the aggregates built BCS basic cube, if possible please let me knows the tweaks.