Member under Insert (top menu).
(NOTE: For more on creating calculated members,
see Lesson One).
Member Builder appears.
into the Member Name box.
In the Value
Expression box, input the following:
Expression box appears as shown below.
Illustration 4: The Value
Expression Box with Inserted Calculation
MyCalcMem2's values equal one-twelfth of
the respective Amount of each row (the "current"
row). The calculation is performed for every cell in the MyCalcMem2 column,
basing its value, in each case, upon the Store dimension's current
newly created MyCalcMem2 column, comparing it to the illustration
Illustration 5: The MyCalcMem2 Value is Based upon the
Store Dimension's Current Member
In the Cube
tree, select MyCalcMem2 in the Calculated Members
folder for the Budget cube.
tab of the Properties pane appears underneath MyCalcMem2.
Select the Parent
Dimension property of MyCalcMem2, on the Basic tab.
Because MyCalcMem2 has Measures as
its Parent Dimension, we see that MyCalcMem2 is technically a Calculated