Show TOC

To work with BEx conditions in AnalysisLocate this document in the navigation structure

In Analysis, BEx conditions correspond to a filter by measure. In SAP Business Explorer, you can define a condition for a query, for a query view or for a workbook:
  • Query conditions are created in BEx Query Designer.

    In the results area of the query, the data is filtered according to the conditions. You can define multiple conditions for a query.

    If you insert a query with condtions in Analysis, you can activate and deactivate the conditions as BEx conditions in the menu.

  • Conditions that are attached to a workbook are created in the BEx Analyzer.

    In the BEx Analyzer, you can activate and deactivate conditions.

    In Analysis, you can activate and deactivate the conditions as BEx conditions in the menu after the workbook conversion.

  • Conditions that are attached to a query view can be created with various BEx tools, for example BEx Web Analyzer.

    If you insert a query view with condtions in Analysis, some of the conditions can not be recognized as BEx conditions. These conditions are displayed as filter by measure in Analysis. Conditions that are not activated in the query view, are not displayed in Analysis.

    In Analysis, you can activate and deactivate the conditions as BEx conditions in the menu or with the Filter by Measure dialog.

Using BEx conditions in Analysis
You can activate and deactivate BEx conditions:
  • To activate a condition, choose Start of the navigation path Filter Next navigation step BEx Condition End of the navigation path and select the condition you want to activate.

    The displayed data in the crosstab is changed according to the condition.

  • To deactivate a condition, choose Start of the navigation path Filter Next navigation step BEx Condition End of the navigation path and select the condition you want to deactivate.

    The displayed data in the crosstab is changed accordingly.

Using BEx conditions as filter by measure in Analysis
The conditions are displayed as rules in the Filter by Measure dialog. You can activate and deactivate the conditions in Analysis:
  • To activate a local condition, choose Start of the navigation path Filter Next navigation step Filter by Measure Next navigation step Edit End of the navigation path.

    The conditions are displayed in the rules section. Press OK to activate the conditions.

  • To deactivate a local condition, choose Start of the navigation path Filter Next navigation step Filter by Measure Next navigation step Edit End of the navigation path and remove all conditions in the rules section that you want to deactivate.

    Press OK to deactivate and delete the conditions. Deleted conditions cannot be activated again.