Click the Check
button to validate syntax.
confirmation dialog appears, indicating valid syntax within the new calculated
measure, as shown in Illustration 6.
Illustration 6: Confirmation
Dialog Indicates Positive Syntax Validation
Click OK to
dismiss the confirmation dialog.
Click OK to
close the Calculated Member Builder.
new calculated measure appears in the tree within the Calculated
With the CM_Cost
with Promo Alloc calculated measure selected, click the Advanced tab
in the Properties pane beneath.
the Format String is set as follows:
The CM_Cost with Promo Alloc calculated measure appears within the Calculated Members folder, with
our selection of Advanced Properties - Format String setting, as
depicted in Illustration 7.
Illustration 7: The New CM_Cost
with Promo Alloc Calculated Measure
calculated members that appear in the illustration above may differ from your
own, depending upon the activities that have been conducted with the Sales
cube in your own environment. As another matter, although the actions we have
performed to this point alone do not require it, let's process the cube to make
sure we are all in a "processed" state.
--> Process Cube to process the Sales cube.
on the Save the Cube dialog that appears next, as shown in Illustration
Illustration 8: Click "Yes"
to Save the Cube
on the dialog that appears next, as shown in Illustration 9; we will not
design aggregations at present.
Illustration 9: Click "No"
to Designing Aggregations
a Cube dialog appears, as depicted in Illustration 10, with the processing method set
to Full Process. Full processing for the Sales cube will be relatively
quick, so we will perform it to ensure that all is refreshed.
Illustration 10: Full
Process Selected in the Process a Cube Dialog
the Full Process radio button is selected on the Process a Cube
to begin processing.
begins. The Process viewer displays various logged events, then presents
a green Processing completed successfully message, as shown in Illustration 11.
Illustration 11: Indication
of Successful Processing Appears (Compact View)
to dismiss the viewer.
Click the Data
tab in the Cube Editor, if necessary.
is retrieved, and we are able to see the values that appear for all measures,
including the new calculated measure, in the Data view.
Drag the Store
Type dimension in the upper half of the Data view to the top of the
left-most column in the lower half - in my case, I am dragging the Store
Type dimension bar over the Country column heading, but your row
axis may be different, depending upon previous activities with the cube.
Type appears in
the place of the previously existing dimension in the row axis.
Drag the Promotions
dimension to the immediate right of the newly placed Store Type column,
to effect a "crossjoin." When the cursor appears as shown in Illustration
12, drop the Promotions dimension.
Illustration 12: Cursor
Indicates Appropriate Drop Point
arrangement should appear as depicted in Illustration 13.
Illustration 13: Arrangement
in the Data View - Partial Row Axis
now see the calculated member exactly as it was constructed by the newly
appointed MSAS Administrator. We will leave the calculated measure in place
until after constructing and testing its replacement, for comparison purposes.