MDX query slower with Calculated Measures on a OLAP Universe
We have BOXI 3.1 ( base version) and we build universe on top of MSAS 2005 cubes and create webi reports against it.
This is what we have noticed.
1. Assume you have a measure like Sales in cube. A report with that measure comes back in decent time.
2. Now the cube has some calculated measures like say Sales MTD or Sales YTD. If i drag one or two of these, the query performance sees a very drastic impact. Same query that used to return in 2 minutes for regular measure now times-out after 30 mins or higher.
Does any one know why calculated measures have this kind of impact? Is there any tuning i can do at the cube level for these calculated measures to improve performance.