Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

MDX query slower with Calculated Measures on a OLAP Universe

All,

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.

Regards

Former Member
Not what you were looking for? View more on this topic or Ask a question