Defining Conditions in a Workbook

Use

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.

For more information about the different parts of the definition and the functions of conditions, seeConditions andDefinition of Conditions.

Prerequisites

The query used meets the requirements specified underConditions andUsing Conditions.

Procedure

  1. To create a new condition, call the Conditions Dialog in analysis mode.
  2. In the BEx Analyzer, in the context menu for the selected cell, choose Query Properties and then the Conditions tab page.
  3. In the context menu, choose Create Condition to create a condition.

    The Conditions Dialog appears.

  4. Enter a description of the condition.
  5. Specify the parameters for the condition.

    You can define one or more condition rows for a condition.

    1. In the screen area of the General tab page, choose New in the context menu. The fields are now input ready.
    2. Select one or more key figures that you defined in the used query.
    3. Select an operator.
    4. Enter a relevant value for the selected operator.
    5. To transfer your specifications to the list of factors, choose Transfer.
  6. Make the characteristic assignments.

    For more information, see Characteristic Assignment inDefinition of Conditions.

  7. Specify whether the condition is active or inactive.

    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

  1. To change your condition or delete a condition row, select the relevant condition row and choose the required function in the context menu.

    To delete a condition, select the relevant condition on the Conditions tab page of the Query Propertiesdialog and choose Delete in the context menu.

Creating a Condition Using the Context Menu

  1. You can also create a condition from the context of the current data cell in the results table. You can do this using one of the following options:
    1. You can choose a condition in the context menu; this condition is based on the context of the selected data cell.

      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.

    2. You can also call the conditions dialog in the context menu for the selected cell and then create a condition as you require.
      • Choose Context Menu for Selected Cell → Create Condition → Using Dialog Box.
    3. You can choose a ranked list condition from the context menu and specify a threshold value.
      • Choose Context Menu for Selected Cell → Create Condition → Set Threshold Value.
    4. Furthermore, you can use the context menu to specify whether a condition is active or inactive.
      • Choose Context Menu for Selected Cell → Toggle Condition State.

More information: