You can define a condition to hide information that is not currently relevant. You can define a condition for a query or a query view. The navigational state of the analysis grid is updated according to your specifications.
Conditions that you create in the BEx Analyzer are local conditions that are attached to the query view. Ensure therefore that local conditions are specific to the workbook that you are saving. You cannot deleteglobal settings.
For more information about the different parts of the definition and the functions of conditions, seeConditions andDefinition of Conditions.
The query used meets the requirements specified underConditions andUsing Conditions.
The Conditions Dialog appears.
You can define one or more condition rows for a condition.
For more information, see Characteristic Assignment inDefinition of Conditions.
To activate the condition, on the General tab page, select the Condition Is Active checkbox. If the condition is active, it is applied to the result set for the query. You can also activate a condition on the Conditions tab page of the Query Propertiesdialog box by using the context menu.
More information:Using Conditions
Deleting or Changing a Condition
To delete a condition, select the relevant condition on the Conditions tab page of the Query Propertiesdialog and choose Delete in the context menu.
The Change and Delete functions in the context menu are only displayed if you defined your condition in the BEx Analyzer. You cannot change or delete conditions that you created in the Query Designer. You only activate or deactivate these conditions.
Creating a Condition Using the Context Menu
The context of the current cell is determined by the value of the cell. The key figure is determined by the position of the data cell. You choose the required operator from the list of condition rows. By default, the last drilldown characteristic in the results table is used as the characteristic assignment.
Note that this context menu is only available if there is no characteristic in the columns and it is not drilled down; otherwise it would be unclear which characteristic assignment is relevant.
Note that the context menu option Toggle Condition Stateis only displayed if you defined at least one condition when defining the data provider (query or query view).
More information: