MDX Variables to Boost OLAP reports performance significantly
Recently I figured out a way to make the OLAP reports significantly faster by avoiding MDX calculations at run time. I got tons of appreciation from my customers on OLAP reports performance.
The trick is using MDX Variables. Please do not try to Google it this is what I named it.
Tags: mdx, performance