O'Reilly logo

Professional SQL Server™ Analysis Services 2005 with MDX by Stephen R. Quinn, Sivakumar Harinath

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

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

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