Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 21, 2009 at 01:38 PM

    Hey

    We make all our calculations in the transformation when we load data. Because we had the same experience.

    Regards,

    Rikke

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 30, 2009 at 05:54 PM

    Thank you folks for your response. These hints have been very useful

    Add comment
    10|10000 characters needed characters exceeded