MDX Performance Tip: Move Calculations From the Query to the MDXScript

In the world of business intelligence, most people prefer to embed as much business logic as possible into the ETL and materialize it in the data model (i.e. data mart, cube, tabular model, etc). After all, if we can take the hit during our batch processing window - then that's time we just saved our users since they won't need to take the hit at query time (e.g. when running a report). Plus it helps ensure 1-version-of-the-truth because report developers and business analysts don't have to recreate the logic.it's baked in.