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

Query MDX use Aggregate ?

Hi,

performing a query MDX I have realized that it doesn't use Aggregates. How can I do for to use Aggregates considering that the query BW on which he founds uses them ?

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 14, 2009 at 07:12 PM

    Hi, thanks the same to everybody. I have already resolved.

    Regards.

    Charly

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Charly1,

      I saw your post in the SDN about MDX and aggregate in BW and would like to share some information (if possible).

      I am interested in enhancing performance for some webi report built on top of a bex query so I started to build some aggregates; I have used trace in RSTT and check how MDX read infoproviders and then built some aggregates. Our webi reports are quite detailed so we are not getting much gain from the aggregates; but still some questions are open for us:

      1. are you really experiencing better performance using aggregates or is it just a matter of cache (bo cache, bi cache..) ?

      2. have you understood how the MDX generate the SQL to extract data from BW? We think that it is the definition of the bex query and not the one from the webi report that drives the extraction; in our solution bex query is bigger than webi report and, above all, it is a very large and complex bex query, so we are afraid that aggregates are not so "important" for webi report.

      Any shared information is welcome, so thanks in advance for answer.

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.