MDX calculation performance

Optimizing the performance of the Storage Engine is relatively straightforward; you can diagnose performance problems easily and you only have two options – partitioning and aggregation – to solve them. Optimizing the performance of the Formula Engine is much more complicated because it requires knowledge of MDX, diagnosing performance problems is difficult because the internal workings of the Formula Engine are hard to follow, and solving the problem is reliant on knowing tips and tricks that may change from service pack to service pack.

Diagnosing Formula Engine performance problems

If you have a poorly performing query, and if you can rule out the Storage Engine as the cause of the problem, the issue is with the Formula ...

Get Expert Cube Development with SSAS Multidimensional Models now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.