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 ?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.