Conditions (SAP Library - Business Explorer)

Conditions

Use

In the BEx Analyzer, you formulate conditions for efficient data analysis. In the results area of the query, the data is restricted according to the conditions so that only the part of the results area that you are interested in is displayed.

Conditions do not affect the results lines, that is, the results lines correspond to the query results lines without this condition.

You can define several conditions for one query. You can link several conditions logically using AND, to make different conditions apply to the query at the same time, as long as they are all active.

Prerequisites

You have defined and executed a query, and now want to define one or more conditions for this query.

Functions

Conditions help you restrict how you view query data in the following way:

Absolute Conditions: A line is filtered independently of the other lines, when its reference value exceeds a specified threshold value.

Ranked Lists: Here, all lines of the displayed list are considered and their relationship to each other decides whether the lines are displayed. Ranked lists are always sorted automatically.

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 or bottom 5 sales volumes

You get a list of the three customers with the highest sales, and also the five customers with the lowest sales.

Top percent, bottom percent: The ranked list is arranged according to a particular percentage.

Material: Top 25% of sales revenue

You get a list of materials with the highest sales volume that account for 25% of the total revenue.

Material: Bottom 25% of sales revenue

You get a list of materials with the lowest sales volume that account for 25% of total revenue.

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:

Product	Sales Volume
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 sum 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.

See also:

Defining Conditions