April 2009
Beginner
448 pages
14h 1m
English
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 ...