In this method, exceptions are highlighted when values meeting the specified condition are found in levels below the level currently displayed in the grid. This is useful for highlighting issues that may not be apparent looking only at the aggregated values.
Define a condition by choosing options in Highlight Data When and At Level, and entering relevant operators and values.
Highlight Data When
Choose one of the following conditions:
|
Choose |
To highlight data when… |
|
There are members |
There are members at specified level for whom Measure.<selected measure> value is … |
|
There are no members |
There are no members at specified level for whom Measure.<selected measure> value is … |
|
Count of members |
Count of members at specified level for whom Measure.<selected measure> value is …, is 'count of members’ |
|
Maximum of members |
Maximum of members at specified level for whom Measure.<selected measure> value is …, is 'maximum of members' |
|
Minimum of members |
Minimum of members at specified level for whom Measure.<selected measure> value is …, is 'minimum of members' |
|
Variance of members |
Variance of members at specified level for whom Measure.<selected measure> value is …, is 'variance of members’ |
|
Stddev of members |
Standard deviation of members at specified level for whom Measure.<selected measure> value is …, is 'stddev of members' |
|
Sum of members |
Sum of members at specified level for whom Measure.<selected measure> value is …, is 'sum of members' |
At Level
Choose the relevant dimension level.
For whom Measure.<selected measure> is
Define the measure value by choosing an operator, specifying a value or range of values.
If this is a percentage value, specify how this percentage should be calculated by choosing the appropriate option from the Compare to Value dropdown list:
And Count of members, Maximum of members, … is
For the conditions Count Of, Maximum Of, Minimum Of, Variance Of, Stddev Of and Sum Of, another line appears for choosing the appropriate operator and value for that condition. For example, "And count of member is=20".
Example
The bubble-up exception highlights the parent cell when a descendant meets the condition. Tooltips show either the description entered in the exception definition or the condition (if a description was not entered), in addition to a list of all lower level members that meet the exception condition.
