Show TOC

Defining SelectionsLocate this document in the navigation structure

You can define selections with and without key figures.

Context

You are on the Sheet Definition tab in the query definition.

Procedure

  1. Define a selection with key figures if this is required for your query definition.
    1. Choose a key figure from the BW Repository and drag it to either the Rows area or the Columns area. The system automatically generates a new structure containing the selected key figure. This structure has the description Key Figures. The system automatically sets the selection for this key figure.
      Note that you can have precisely one key figure structure per query. If you want to use more than one key figure, the key figure structure must contain all of these.
    2. To restrict a key figure, open the context menu for the key figure in question and choose Edit. The Edit Selection dialog box appears. In the properties of the key figure, you see the selection in the General tab under Selection Details.
      Note that you can only use a key figure restricted in this way in the current query. You can find all restricted key figures used in queries for an InfoProvider by choosing Start of the navigation path Reusable Components Next navigation step Restricted Key Figures End of the navigation path in the BW Repository.
  2. Define a selection without key figures if this is required for your query definition.
    1. Choose New Selection from the context menu for the required structure. The Edit Selection dialog box appears.
    2. Add the required characteristic.
    3. Select the required characteristic values and confirm your selection by choosing OK.