The scope of a measure depends on its relationship to the levels in the Dimension
Map.
Level Derived Directly
In this case, the dark yellow color indicates that the level takes its category values
directly from the measure.
In this example, the levels Year, Quarter, and Month are directly associated with
the measure, while the lowest level, Day, is associated with another measure.
Level with Allocated Measures
In this case, the green color indicates that the level values are allocated either by a
constant or proportionally to another measure.
In this example, the dimension contains a level named Player, whose measure
values are allocated proportionally to an ancestor level.
Calculated Measure Scope
If a calculated measure is based on two regular measures, the measure scope
dimension map shows the lowest common level. If the lowest common level is
allocated, the level appears with the same shading (green) for both the allocated
measure and the calculated measure.
Procedure
1. In the Measures list, select the measure whose scope you want to see.
2. From the Edit menu, click Show Scope.
Note: You can change the default colors of the scope map on the Dimension
Map tab in the Preferences property sheet on the File menu. Click the color
swatch you want to change and select a new color from the Color palette. Click
OK twice.
Set Dimension Allocation
Cognos Transformer automatically allocates a measure as a constant throughout an
entire dimension when the source of the measure does not reference that
dimension.
Chapter 5. Modeling Your Key Performance Measures 111
To Next Page
Loading...
Need help?
General