Professional SQL Server™ Analysis Services 2005 with MDX

9.3. Adding Calculations to Your Cube

In Chapter 6, you learned how to use the Calculations tab in the cube designer for creating calculated members and named sets. In Chapter 7, you learned about the calculation model in Analysis Services 2005 and how cell calculations are created within MDX Scripts. In this section, you learn how to review and test cell calculations.

You use the Calculations tab in the cube designer to define all calculations which then become part of the MDX script of your cube. In this section, you continue using the Adventure Works DW sample project included with Microsoft SQL Server 2005 product to explore the functionality available in the Calculations tab.

The following steps show how to review the definitions of some of the calculations defined in the Adventure Works sample cube and how to verify the results as the calculations are applied to the specific cells:

1. Open the Adventure Works DW sample project located at C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project\Enterprise and, if you haven't done so already, deploy the project to the Analysis Services instance on your machine. If you have a default Analysis Services instance, you can deploy the project without changing the project properties. However, if you have installed named instances of Analysis Services and SQL Server you must change the project's deploy properties to target the right instance of Analysis Services and you must also change the relational ...