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 ...
Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.