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

Creating Calculated Members

The simplest calculated members apply an arithmetic operation to a few measures. In Chapter 5, you created a simple calculated member that was the sum of two measures. In this section, you will create a calculated member that contains a ratio of two measures. The ratio will be one tuple that contains a single measure divided by another tuple that also contains a single measure. When a tuple contains only a measure, it is implicitly including the current member of each of the dimension attribute hierarchies.

The MDX formula in a calculated member is applied to the measures after they are aggregated. In some instances, aggregating numeric values and then applying a formula is not equal to applying a formula to numeric ...

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