Microsoft® SQL Server™ 2000 Analysis Services Step by Step

Calculating Relative Contribution

A tuple such as [Sales Units]—which uses an explicit member name from one dimension—are very common in MDX expressions. A tuple such as ( [Dairy], [Sales Units] )—which uses explicit member names from two or more dimensions—are quite rare. Usually, when you explicitly include members from more than one dimension in a tuple, you use functions to calculate a member based on the current member.

Using CurrentMember in a LookupCube Function In “Use a custom member formula” in Chapter 4, “Advanced Dimensions and Cubes,” you associated a custom formula with the Revenue member of the Finance cube. The formula was already stored in the database. You can now understand the formula needed to look up a value from a different ...