Calculation Scripting

When you first create a cube, a default MDX script that defines calculations in the cube is also created. This script is identified by the Calculate command that appears first in the Script Organizer of the Calculation tab of the Cube Designer. You add to this script every time you create a new calculated member. This script tells the server to calculate the entire cube on the first pass. The MDX expressions and statements that you add to the MDX script then get resolved in the order in which they appear in the Script Organizer.

You can use the debugging features in Microsoft Visual Studio to observe the interaction of calculations during execution of the MDX script. As you step through the script, you use the debugger’s cube ...

Get Microsoft® SQL Server® 2008 Analysis Services Step by Step now with O’Reilly online learning.

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