You can define several conditions for a query. When displaying in Web applications (including the BEx Web Analyzer) or in the BEx Analyzer, you can activate or deactivate conditions to generate different views of the data.
Displaying Conditions
You can display the descriptions of conditions for a query.
The existing conditions of a query view and their associated statuses are displayed in theList of Conditions web item.
You can also navigate to this function in theBEx Web Analyzer by choosing Settings → Conditions Tab Page.
In the context menu, you can navigate to the existing conditions by choosing Filter → Conditions.
The existing conditions and their associated statuses are displayed in theList of Conditions design item.
Using Several Conditions in a Single View
If you have set a condition to Active in the definition, the status Active appears next to the description of the condition. If several conditions are defined for a query, it can result in conflicts between conditions that refer to the same characteristics. In this case, certain rules of priority apply. Generally, the most specific condition applies when there are conflicts.
One condition defines the Top 5 Sales for the characteristic Customer, and a second condition defines the Bottom 3 Sales in the customer-product combination.
If only the characteristic Customer is in the drilldown, only the first condition applies. Therefore, only the condition Top 5 Sales is used for the characteristic Customer.
If Customer andProduct are both in the drilldown, you can use both conditions in accordance with their definitions. In this case, the second condition applies since it is more specific due to its reference to the characteristic combination.
If a condition cannot be used in a query, the following status descriptions can appear in the display:
The condition refers to, for example:
a characteristic that has not been drilled down
a characteristic combination and the two characteristics are not drilled down next to each other on an axis
a characteristic combination and an involved characteristic are not drilled down
a characteristic combination and the axis has a hierarchical display, whereas the condition is a ranked list
a characteristic that is drilled down with an active presentation hierarchy, whereas the condition is a ranked list (seeHow Conditions Interact with Hierarchies)
The condition refers to a characteristic that is already being used in another active condition. There is a collision. Only when you deactivate the other condition does this condition come into effect. The status appears as Active in the display.
Condition 1: Customers: Top 3 or bottom 5 sales volumes
Condition 2: Customers and products: Purchase order value > 50,000
If the characteristics Customers and Products have been drilled down and condition 2 is active, then condition 1 automatically has the status Not Used. If you deactivate condition 2, condition 1 is automatically activated. If you activate condition 1, condition 2 is automatically Not Used.
Activating/Deactivating Conditions
BEx Web applications:
In the List of Conditions Web item, you can activate or deactivate conditions using Switch Status. You navigate to this function from the BEx Web Analyzer by choosing Settings → Conditions Tab Page → Switch Status.
BEx Analyzer:
In the List of Conditions design item, you can activate or deactivate the conditions using the context menu.