Conditions 
Use
You can formulate conditions to make data analysis more efficient. 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 numbers. Instead, you are just hiding the numbers that are not relevant for you. For this reason, conditions have no effect on the displayed values of the results rows. The results row of a query with an active condition corresponds to 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. In doing so, the results quantity for the evaluation sequence is independent. 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 Sales and Invoiced Quantity > 100,000,000).
Integration
The conditions function for defining 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 Web item List of Conditions
¡ In the context menu
· In the BEx Web Analyzer
Prerequisites
You have defined a query, have used this query if necessary as a data provider in a Web application or as a data provider for design items in the BEx Analyzer, and would now like to define one or more conditions for this query.
Features
Conditions help you restrict how you view query data in the following way:
· Threshold values: An entry is filtered independent 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 goes below 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 here and their relationship to another determines whether the entry is displayed. For ranked lists, the sorting is switched on automatically when the condition is activated.
The following operators help you to create rank lists:
· Top N, Bottom N: The ranked list is arranged according to a particular number.
Customers: Top 3 with bottom 5 sales volumes
You get a list of the three customers with the strongest sales and the five customers with the weakest sales. This means that you see the set 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 – related to revenue - until 25% of the total revenue is attained.
Material: Bottom 25% of sales revenue
You receive a list of the weakest materials – related to revenue - until 25% of the total revenue is attained.
· Top total, bottom total: The ranked list is arranged according to a particular totals value.
Products: Top total 20,000 EUR of sales volume
You get a list of products with the lowest sales volume, whose combined sales volume makes a total of 20,000 EUR. First, all sales volumes are sorted in descending order and then totals are formed until the threshold value of 20,000 is exceeded. Those products that exceed the 20,000 EUR threshold are left in the list.
The ranked list for this condition might look like this:
Products |
Sales |
A |
11,000 EUR |
B |
7,000 EUR |
C |
5,000 EUR |
Product C is included in the list, even though it means the total is greater than 20,000 EUR. All the 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 whose combined sales total a certain amount, use the Bottom total operator.