Basics and Example Scenarios for Conditions

In this section, the basis for using conditions is explained and illustrated by means of example scenarios.

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.

  SeeRanked 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.

  SeeLinking 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.

  SeeRanked 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.

  SeeRanked List Condition for All Characteristics in Drilldown Independent: Top 3 Products and Top 3 Sales Channels andConditions 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.

  SeeQuery 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 (seeQuery 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 (seeQuery with a Presentation Hierarchy and Conditions).

  The system attempts to adapt the list display to these prerequisites by automatically activating the results row suppression (seeBackground Information for Conditions, section Conditions on Characteristic Combinations).

  SeeRanked 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.

  SeeQuery with a Display Hierarchy and Conditions andQuery 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.

  SeeThreshold 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.

  SeeConditions 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

  SeeQuery with a Display Hierarchy and Conditions andQuery 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, seeBasics and Example Scenarios for Conditions.