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.
You can display the descriptions of conditions for a query.
● BEx Web applications:
The existing conditions of a query view and their associated statuses are displayed in the List of Conditions web item.
You can also navigate to this function in the BEx Web Analyzer by choosing Settings → Conditions Tab Page.
In the context menu, you can navigate to the existing conditions by choosing Filter → Conditions.
● BEx Analyzer:
The existing conditions and their associated statuses are displayed in the List of Conditions design item.
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 and Product 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:
● cannot be applied
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 (see How Conditions Interact with Hierarchies)
● not used
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.
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.
In the List of Conditions design item, you can activate or deactivate the conditions using the context menu.