To make a long story short – Do not use formatting in MDX when using results for Reporting Services. You’ll only get performance issue using formatting in MDX.
Here’s a little tip for all who works with MDX and gets stuck on the performance.
Sometimes when you work on MDX queries the performance is very slow. This even though the resultset is only a few rows. (I know that the dataintegrity also is a role player here…).
But but, I’ve come up with a little finding.
If you have used formatting directly in your MDX query in order to get the whole thing done from the SSAS servers power, then it’s actually a lot faster to get Reporting Services to do the formatting for you.
I didn’t now this, it’s possible that many of you allready did. I know that I’ve learned something new today.
Subscribe to my channel
Free Microsoft Workshops
