Skip to Content
author's profile photo
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 comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

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

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

    Regards.

    Charly

    Add 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.