In this example, we do
not provide a surrogate value for cells that meet the condition, but use the
condition as a basis for the application of exception highlighting only.
Therefore, the address of the current cell is appropriate. We use the CalculationPassValue()
function to prevent the expression from referencing itself, once again (via the
same logic we used in the calculation formula in the last step).
We arrive at the Finish
the Calculated Cells Wizard dialog box. We provide the name Warehouse
Cost Subanalysis Scope, to define a list of warehouses whose level of costs
exceeds the threshold of our scope for further examination. We see a summary of
the parameters we have assigned through the wizard for the calculation
subcube (defaults were assigned for dimensions that we did not specify). In
addition, we see a confirmation that the calculation condition has been
The Finish the
Calculated Cells Wizard dialog box appears, as shown in Illustration 9.
At this point in the
calculated cells creation process, we have a new calculated cell that has no
display criteria. We should see the calculated cell Warehouse Cost
Subanalysis Scope in the left side of the Cube Editor within the
appropriate folder of the tree pane, as depicted in Illustration 10).
Illustration 10: The New
Calculated Cell Appears in the Tree
for the Calculated Cell
We now need to set the
display properties for the calculated cell. We do this in a manner very
similar to that in which we set properties for calculated members.
Click once to select the Warehouse
Costs to Subanalyze calculated cell.
Expand the Properties
pane in the lower tree pane.
Click the Advanced tab.
The Properties pane--Advanced
tab appears, as shown in Illustration
Illustration 11: The
Properties Pane - Advanced Tab
and BackColor cell properties are used to store color information for the
text and the background of a cell, respectively. The color and hue
are defined in these properties boxes using an RGB value (the Microsoft
Windows operating system red-green-blue format).
Any color in the
spectrum exists at some intersection point of the basic colors (or as a "pure"
color). A few common examples of intersect values are depicted in Illustration 12.
Illustration 12: Color
Definitions from the Perspective of RGB