Using Conditions

This section provides a guide to using conditions, together with a number of example scenarios.

Note that the system processes conditions according to the following rules:

• Rule 1: If you apply conditions to a query, you do not change any numbers. You merely hide numbers that are not relevant for you. This means that conditions do not have any effect on results rows. The results row of a query with an active condition is the same as the results row of the query without a condition.

  See Ranked List Condition: Top 5 Products

• Rule 2: If a query has more than one condition set for it, these are logically linked by AND. The 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 meets all (active) conditions in 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 meets at least one of the condition rows.

  See Ranked List Condition with 2 Condition Rows: Top 2 Products and Bottom 2 Products

• Rule 4: The All Characteristics in Drilldown Independent setting means that each characteristic in the drilldown has its own (identically named) condition defined for it These conditions are linked with AND in accordance with rule 2. The All Characteristics in Drilldown Independent setting enables you to be able to use a condition in a general way. This 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 For All Characteristics in Drilldown Independent condition 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 in accordance with rule 4.

  See Query with Condition and Results Row Suppression

• Rule 6: With multiple characteristics, the Single Characteristics and Characteristic Combinations setting 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 if the following prerequisites are met:
  • Both characteristics are in the drilldown.
  • Both characteristics are on the same axis.
  • The two characteristics are immediately 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 results row suppression (see the Conditions on Characteristic Combinations section in Background Information for Conditions)

  See Ranked List Condition for Characteristic Combination: Top 10 Combinations from Product and Sales Channel

• 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 (one which contains characteristics both in its rows and its tables), 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 meet 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 a results row on this multi-level drilldown list does not meet the conditions and is thus filtered out, all associated detail rows and detailed (interim) results rows disappear.

  See Condition for All Characteristics in Drilldown Independent

• Rule 10: If a threshold value condition is applied to a characteristic with an active presentation hierarchy, 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 in the drilldown meets the condition.

  The same applies 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.

See also:

For more information about how conditions are applied in queries with two structures, active presentation hierarchies and hierarchically displayed axes, see Basics and Example Scenarios for Conditions.