within our current example, let's look further at retrieving values, by taking
the following steps.
Swap the Store dimension
and the Measures dimension.
Store dimension appears in the rows axis, presenting the results set shown
The Store Dimension replaces the Measures Dimension.
in the Calculated Members folder of the Budget cube.
Select the Value
property for MyCalcMem2.
Click the ellipsis button ("..")
once again, to raise the Calculated Member Builder dialog.
Type the following into the Value Expression box.
Click OK to close the Calculated
Data Viewing pane appears as shown in Illustration 11 below.
The Tuple Appears in the Calculated Member.
The total for the Mexican
locations' Net Income (or, as we explained earlier, the Total
Expenses, as no Revenues amounts are stored in the Budget
cube) appears in every cell of the MyCalcMem2 row. Besides the
two dimensions that we specified (Net Income and Mexico),
the current member is implicitly used to satisfy the requirement
for the identification of the remaining dimensions' members. In other
words, the two dimensions specified in the tuple, together with the current
members for any unspecified dimensions, compose the coordinates for
the cell, and, contextually, the value of the cell.
Select the Parent Dimension property
of Calculated Member MyCalcMem2.
Select the Account
dimension via the drop-down arrow.
Click any place on the Data
tab, Data Viewing pane, to refresh.
Swap the Measures
dimension with the Store dimension, placing the Measures
dimension in the rows axis.
results set appears as below.
does not Change.
we see in the illustration, the MyCalcMem2 column shows the Net
Income figure for the Mexican stores; the presence of the Mexico dimension in MyCalcMem2 specifies the Mexico
member of the Store dimension as part of the context within which the
value is derived.