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

Aggregate at each profit center hierarchy level

We're creating a MultiProvider over 4 multi-million-row cubes, and a Bex query where many users will need to drill down to each level of Profit Center Hierarchy with 5-second response time. I'm starting to create an aggregate at each Profit Center hierarchy level. Does that sound reasonable?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 31, 2005 at 07:48 PM

    Could be reasonable, but I think I would want to know at the point they are drilling to the Profit Center level, how much of the data has already been filtered out? That is, are they looking at a very small subset of the rows in the fact table or a larger chunk?

    How many InfoProviders are in the MP? You will gain the parallel processing feature of using a MP, so you may find that performance is adequate without the multiple aggregates.

    Another possibility is loading up the entire results into OLAP cache which would provide better performance than aggregates.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi

      i am facing the same scenario. Just a costcenter with hierarchy in a query (built on multiprovider). no key figures.

      Query performance is bad because all 4 cubes have millions of records.

      Thinking if we have to go for aggregate?

      hierarchy table has maximum of 2500 records. hierarchy level 1 is used in the query. please help what would be the best solution to increase the performance?

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.