Performance issue using formatting in MDX

ActivityMonitor

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.

And yes, this is also a matter of hardware, network, setup, configuration etc. etc. But the bottom line is Reporting Services are a whole lot faster to render the formatting than compared with Analysis Services and MDX.

Få besked om næste indlæg

Skriv dig gerne op til at modtage en mail, ved næste indlæg. Det kan du gøre nedenfor.



Marketing stuff

Our emails contain marketing stuff, so we need to give you some fine quality fine print: brianbonk will use the information you provide on this form to email you with updates and marketing. You can change your mind at any time by clicking the unsubscribe link in the footer of any email you receive from us, or by contacting us at help@brianbonk.dk. We use Mailchimp as our marketing platform. By checking the box to subscribe, you acknowledge that your information will be transferred to Mailchimp for processing, and that we may process your information in accordance with these terms.

Følg mig på Instagram

Leave a Reply

Your email address will not be published. Required fields are marked *

en_USEnglish