Skip to Content
author's profile photo Former Member
Former Member

Aggregates possible on multi-provider?

Hello,

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?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jun 14, 2005 at 06:00 PM

    Hi Ashouja,

    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.

    Hope this helps...

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ashouja,

      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.

      regards

      Siggi

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.