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