MDX Code much slower than MDX Browser

63 views Asked by At

When I browse my Cube and drag/drop different elements for calculations I get my results within a second or two. However, my MDX code (created by the Wizard) takes around 6 minutes or so.. let's say I have 10 instances of what I drag/drop for calculation, even so, it should not take more than 10 seconds.. let alone 6 minutues!! thank you so much for your help.

1

There are 1 answers

5
SouravA On

Browser creates an unoptimized code in the background. To have a look at the code generated by the browser, click on the "Design Mode" icon.

enter image description here

You will often see the code riddled with number of subcubes, which might seem non-intuitive and ineficient coding practices.

As far as I know, there is no way to control this code. Deal with it! And use MDX to query your cube's data.