Basics and Example Scenarios for
Conditions
Use
In this section, the basis for using conditions is explained and illustrated by means of example scenarios.
Overview
Note that the system processes conditions according to the following rules:
● Rule 1: If you apply conditions to a query, you are not changing any numbers. Instead, you are just hiding the numbers that are not relevant for you. This means that conditions do not effect results rows. The results row of a query with an active condition corresponds to the results row of the query without a condition.
See Ranked List Condition: Top 5 Products
● Rule 2: Multiple conditions in a query are logically linked by means of AND. Conditions are evaluated independently of each other. The result set is therefore independent of the evaluation sequence. The intersection of conditions is displayed in the query. A characteristic value is only displayed if it fulfills all (active) conditions of the query.
See Linking Two Conditions: Bottom 2 Revenue and Invoiced Quantity > 100.000.000
● Rule 3:The condition rows for a condition are logically linked with OR. The union of conditions row results is displayed in the query. A characteristic value is displayed if it fulfills at least one of the condition rows.
See Ranked List Condition with Two Condition Rows: Top 2 Products and Bottom 2 Products.
● Rule 4: The setting All Characteristics in Drilldown Independent means that each characteristic of the drilldown has a condition (identical) defined for it These conditions are linked with AND according to rule 2. The setting All Characteristics in Drilldown Independent enables you to be able to use a condition in a general way. It is especially useful for threshold value conditions with relative key figures and ranked list conditions.
See Ranked List Condition for All Characteristics in Drilldown Independent: Top 3 Products and Top 3 Sales Channels and Conditions for All Characteristics in Drilldown Independent.
● Rule 5: If a condition For All Characteristics in Drilldown Independent is active in a query and results row suppression is active for some characteristics, the system still generates all results and applies the condition(s) to each of these results levels according to rule 4.
See Query with Condition and Results Row Suppression
● Rule 6: With several characteristics, the setting Single Characteristics and Characteristic Combinations always stands for the combination of these characteristics and not for a set of (independent) characteristics. A condition on a combination of characteristics is only applied when the following prerequisites have been fulfilled:
○ Both characteristics are in the drilldown.
○ Both characteristics are on the same axis.
○ The two characteristics are next to one another.
○ The axis upon which the two characteristics are drilled down has no hierarchical display (see Query with Hierarchically Displayed Axis and Conditions.)
○ If one of the two characteristics has an active presentation hierarchy, only one threshold condition can be applied for the characteristic combinations, but not a ranked list condition (see Query with a Presentation Hierarchy and Conditions).
The system attempts to adapt the list display to these prerequisites by automatically activating the results row suppression (see Background Information for Conditions, section Conditions on Characteristic Combinations).
● Rule 7 Ranked list conditions cannot be applied to characteristics with active display hierarchies.
See Query with a Display Hierarchy and Conditions and Query with Two Display Hierarchies and Conditions.
● Rule 8: In a cross-classified table (meaning characteristics are not only in the rows, but also in the columns), conditions are only applied to the axes. The axes span across the border of the matrix and all cells are displayed for which both the rows and the columns correspond to the active conditions.
See Threshold Condition for a Characteristic in a Cross-Classified Table
● Rule 9: If there are several characteristics in the drilldown and if a results row on this multi-level drilldown list does not fulfill the conditions and is then filtered out, then all of the associated detail rows and detailed (interim) results rows disappear.
See Conditions for All Characteristics in Drilldown Independent
● Rule 10: If a threshold value condition is applied to a characteristic with an active presentation hierarchy, then a node that actually does not fulfill the condition and would normally be filtered out is shown anyway if at least one of the subordinate nodes fulfills the condition.
The same is valid for
○ Conditions on characteristic combinations if the (interim) results rows are being displayed
○ Conditions on hierarchically displayed axes
See Query with a Display Hierarchy and Conditions and Query with Two Display Hierarchies and Conditions.
More Information:
For more information on the application of conditions in queries with two structures, active presentation hierarchies and hierarchically displayed axes, see Basics and Example Scenarios for Conditions.