Performance issue using formatting in MDX

Posted on Leave a commentPosted in Database, Development, MDX, Reporting Services

To make a long story short – Do not use formatting in MDX when using results for Reporting Services. 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, […]