Is it possible to have aggregates on multi-provider?
how do queries built on Multi-provider utilize aggregate; does it help to create aggregates on individual infocube, do they look for aggregates on individual Info-cubes?
It is not possible to create aggregates based on multiproviders as MP themselves do not contain any data. Maintaining aggregates on the base cubes will definitely help. A query based on a MultiProvider is actually divided into sub-queries during execution time. The sub-query is generated for each InfoProvider associated with the MultiProvider.
goto transaction rsrt and run your multicube query in debug mode. Check the option for display the aggregates and it will show you wether it uses a aggregates or not and in addition what aggregates it expects and you can build your aggregates based on this information on the basis cubes.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.