Microsoft® SQL Server™ 2000 Analysis Services Step by Step

Creating Calculations by Using Aggregation Functions

In Chapter 6, you created calculated members in a cube by using arithmetic operators and discrete values. Now that you know how to use sets, you can create calculated members that use aggregation functions. First, however, create a simple calculated member within an MDX query statement. The calculated member created as part of an MDX statement works the same as one created in a cube, except that when stored in the cube the member is permanent and is available to all users of a cube. Sometimes it can be effective to create calculated members in a query statement as you develop them and then copy the expressions to a cube when you’re satisfied with them.

Create a Calculated Member as Part of ...