Example: Constant Selection on a Compound Characteristic
The following example illustrates why with characteristics set as constant it is also advisable to add compound characteristics to the selection and to set them as constant too.
Let us assume that characteristic C is dependent on characteristic P. C is also filtered to an individual SID - by a hierarchy node for example and is set to contant selection (CSC) in a structure element Eo. This means implicitly that P is also filtered to the unique value. As the constant selectoin on C does not have any effect on P however, a fixed or dynamic filter on P that does not contain po would prevent Eo from providing any data. In this case, we also recommend adding P to the selection of Eo without filters and setting it as constant. This rule is illustrated in the following simple example.
The 'Region' characteristic (compounded with the 'Country' characteristic) has the following characteristic values:
Country |
Region |
|---|---|
DE |
BW |
DE |
BAY |
DE |
HAM |
US |
NY |
There is also a hierarchy on the Region characteristic. The South Germany hierarchy node contains the following leaves: DE-BW and DE-BAY.
We assume that the hierarchy selection Region Southern Germany is set to constant selection (CSC) in a structure element. This means that the implicit country filter for this cell is set to DE, but is not constant. A dynamic filter set to Country = US means that the cell does not return any more data. If the Country is also set to constant selection (CSC) however, the cell continues to return data for South Germany.