In this section, we will explain enhanced basics for using conditions in connection with two structures, active presentation hierarchies and hierarchically displayed axes, illustrated with example scenarios.
Take note of the following when using conditions if you are using two structures, active presentation hierarchies, the function Display as Hierarchy on axes or the property Suppress Results Rows in a query:
SeeQuery with Two Structures and Threshold Value Conditions: And/Or-Linking andQuery with Two Structures and Ranked-List Conditions.
SeeQuery with a Presentation Hierarchy and Conditions andQuery with Two Presentation Hierarchies and Conditions.
The following table shows which types of conditions are possible in the various queries and what you need to watch for, for example, when you use active presentation hierarchies in the query.
Special Features and Applicability of Conditions
Threshold Conditions | Ranked List Conditions | ||
---|---|---|---|
Condition for single characteristic |
Without presentation hierarchy |
Possible |
Possible |
With presentation hierarchy |
Possible |
Not applicable |
|
Axis displayed hierarchically |
Possible as long as the hierarchical display is expanded up to this characteristic. |
Possible as long as the hierarchical display is expanded up to this characteristic. |
|
Condition for all characteristics in drilldown independent |
Characteristics on an axis |
Possible |
Possible as long as the characteristics do not have a presentation hierarchy |
Characteristics on both axes (cross-classified table) |
Possible |
Possible as long as the characteristics do not have a presentation hierarchy |
|
Axis displayed hierarchically |
Possible and is applied up to the last characteristic in the expanded hierarchy. |
Possible and is applied up to the last characteristic in the expanded hierarchy. |
|
Condition for characteristic combination |
All involved characteristics next to one another on an axis |
Possible |
Possible as long as the characteristics do not have a presentation hierarchy |
Involved characteristics separate and not on one axis |
Not applicable |
Not applicable |
|
Axis displayed hierarchically |
Possible as long as the hierarchical display is expanded up to the characteristic that is part of the characteristic combination. |
Not applicable |