Category Archives: MDX Performance

MDX Performance improvement on MAX aggregation

Today I offered what I think was quite a clever solution to improve a fellow community members MDX query using a MAX aggregation. It took his query time down from 8 minutes to a fraction of a second 😉   … Continue reading

Posted in Analysis Services, MDX Performance | Leave a comment

MDX Scope VS Pre Aggregated measures.

MDX Scope VS Pre Aggregated measures. So I looked into the use of Scope in MDX and compared it to using pre aggregated measures in the cube. I am a big fan of handling any type of row level business … Continue reading

Aside | Posted on by | Leave a comment

Multi select – friendly time calculations in Analysis Services.

Multi select – friendly time calculations in Analysis Services. By Duane Dicks – ditchie@gmail.com SSAS is blessed with a variety of built in time calculations, as well as many methods of creating your own calculations, for when your time dimension … Continue reading

Posted in Analysis Services, MDX Performance, MDX Time calculations, SQL, TSQL | Leave a comment