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 ...