Skip to Main Content
Microsoft® SQL Server® 2008 Analysis Services Step by Step
book

Microsoft® SQL Server® 2008 Analysis Services Step by Step

by Scott Cameron
April 2009
Beginner content levelBeginner
448 pages
14h 1m
English
Microsoft Press
Content preview from Microsoft® SQL Server® 2008 Analysis Services Step by Step

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® SQL Server™ 2008 Analysis Services Unleashed

Microsoft® SQL Server™ 2008 Analysis Services Unleashed

Irina Gorbach, Alexander Berger, Edward Melomed
Microsoft® SQL Server™ 2005 Analysis Services Step by Step

Microsoft® SQL Server™ 2005 Analysis Services Step by Step

Reed Jacobsen, Stacia Misner, Hitachi Consulting

Publisher Resources

ISBN: 9780735626201Supplemental ContentCatalog PageErrata