cancel
Showing results for 
Search instead for 
Did you mean: 

Aggregates

Former Member
0 Kudos

Hi experts

We have a cube on which there are aggregates..we created a multiprovider consisting of 3 cubes in which one cube consists of aggregates...when we execute a query does the OLAP process gets the data from the cube or aggregates?

REgards

Annie

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Annie,

In my opinion, the OLAP processor will go to the appropriate aggregates to fetch the data and if it doesn't find them for the infocube than it will fetch the data from the infocube.

Hope it makes some sense!!!!

Regards,

Amit

Former Member
0 Kudos

the query which sit on multi-cube can use underlying aggregates on sub-sub if you create query in appropriate way.

Tcode: RSRT to analysis whether the query used aggregate or not.

edwin_harpino
Active Contributor
0 Kudos

hi Annie,

there will be such 'sub query' that fetch data from infocube or aggregate. depend on the query, it will fetch from aggregate or cube, first 'priority' aggregate.

you can use rsrt and 'execute+debug' with option 'display aggregate found' to check if aggregate used. hope this helps.

Former Member
0 Kudos

Hi Annie.

If create query on multiprovider ,query will be split from OLAP processor,and fetch the date from different cubes and combine send to Bex.if you we have aggregates for the cube ,OLAP processor first hit the Aggregate.

Regards.

harry

Answers (0)