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

Get Microsoft® SQL Server® 2008 Analysis Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.