O'Reilly logo

Microsoft® SQL Server® 2008 Analysis Services Step by Step by Scott Cameron

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required