MDX script's functionality
You already saw a couple of examples for defining calculated measures in the MDX script found on the Calculations tab within SSDT. Some MDX functionality applies only within the MDX script and not in queries. For example, you could define the calculation scope so that it only applies to certain hierarchy members. You can also use the ROOT function to refer to the topmost level of the hierarchy. The ROOT function isn't specific to the MDX script, but it is most commonly used in cube-level calculations.
The MDX script is evaluated when you first deploy the solution and anytime you change calculations; it doesn't require processing any objects (dimensions or partitions), but it could overwrite the existing cube values. Full ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
