February 23, 2009 at 6:31 pm
I have a calculated measure that is summing up YTD values that includes filters based on a couple of dimensions.
If I write a query of salesperson vs time using this calc measure it takes for ever.
This is true if i even apply slice filters for only one month.
However, if i use Excel connected to the cube I can apply exactly the same filters manually (ie not use calc measure), response is lightning quick.
This tells me that it is probably not the DW structure, but something to do with the measure and/or aggregations being applied.'
Does anyone know how to troubleshoot this kind of issue (any tools to retrieve anything similar to SQL execution plan or any thing else to point out where this performance bottleneck could be).
Many thanks in advance.
Smurph
February 23, 2009 at 7:38 pm
If you provide the MDX that you are using we can review the calculations. If you are looking for a tool to evaluate and analyze your MDX and performance I would recommend MDX Studio by Mosha. You can download the latest release from here - MDX Studio v.0.4.12.
He does have an online version here http://mdx.mosha.com/[/url] that you can take a look at and he also has a screencast that you can check out here that is available to download in this posting Screencast of “MDX Studio to the rescue” presentation.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
July 15, 2009 at 9:05 am
Acn you provide the MDX? Sometime the IIF function slows things dow. Use case instaed;-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply