Conditions
Use
To improve the efficiency of data analysis, you can formulate conditions. In the results area of the query, the data is filtered according to the conditions so that only the part of the results area that you are interested in is displayed.
If you apply conditions to a query, you are not changing any figures; you are just hiding the numbers that are not relevant for you. Conditions therefore have no effect on the values displayed in the results rows. The results row of a query with an active condition is the same as the results row of a query without this condition (see Ranked List Condition: Top 5 Products).
You can define multiple conditions for a query. Conditions are evaluated independently of each other. The result set is therefore independent of the evaluation sequence. The result is the intersection of the individual conditions. Multiple conditions are linked logically with AND. A characteristic value is only displayed when it fulfills all (active) conditions of the query (see Linking Two Conditions: Bottom 2 Revenue and Invoiced Quantity > 100,000,000).
Integration
The function for defining conditions is available in the following areas of the Business Explorer:
● In the BEx Query Designer (see Defining Conditions)
● In Web Applications (see Defining and Changing Conditions)
○ In the List of Conditions Web item
○ In the context menu
● In the BEx Web Analyzer
● In the BEx Analyzer (see Defining Conditions in a Workbook)
Prerequisites
You have defined a query, you use this query if applicable as a data provider in a Web application or as a data provider for design items in the BEx Analyzer, and want to define one or more conditions for this query.
Features
Using conditions, you can restrict how you view query data as follows:
· Threshold Values: An entry is filtered independently of the other entries if its reference value has a specific relationship to a comparison value. For example, an entry is not displayed if its reference value exceeds or is less than a specific threshold value.
· Ranked List: All entries for the displayed list or all entries for a logical section of the list (with multiple characteristics in the drilldown) are considered and their relationship to each another determines whether the entry is displayed. For ranked lists, the sorting is switched on automatically when the condition is activated.
You can use the following operators to create ranked lists:
● Top N, Bottom N: The ranked list is arranged according to a particular number.
Customers: Top 3 with bottom 5 sales volumes
A list of the three customers with the strongest sales and the five customers with the weakest sales is displayed, that is, the union of both condition rows Top 3 Sales and Bottom 5 Sales.
● Top Percent, Bottom Percent: The ranked list is arranged according to a particular percentage.
Material: Top 25% of sales revenue
You receive a list of the strongest materials – with respect to revenue – until 25% of the total revenue is attained.
Material: Bottom 25% of sales revenue
You receive a list of the weakest materials – with respect to revenue – until 25% of the total revenue is attained.
● Top Total, Bottom Total: The ranked list is arranged according to a particular total value.
Products: Top total EUR 20,000 of sales volume
You get a list of products with the highest sales volume, for which the combined sales volume totals EUR 20,000. All sales volumes are first sorted in descending order. Then totals are calculated until the threshold value of 20,000 is exceeded. Those products that exceed the EUR 20,000 threshold remain in the list.
An example of the ranked list for this condition is as follows:
Product |
Sales |
A |
EUR 11,000 |
B |
EUR 7,000 |
C |
EUR 5,000 |
Product C is included in the list, even though the total then exceeds EUR 20,000. All products that have a lower sales volume than product C are no longer displayed.
If you want to create a ranked list of the products with the lowest sales volume for which the combined sales total a certain amount, use the Bottom Total operator.