Show TOC

Defining SelectionsLocate this document in the navigation structure

Use

You can define a query by dragging the key figures from the InfoProvider to the directories in Query Designer. If you drag a key figure into the rows or columns, this key figure automatically becomes part of a structure.

You can restrict (filter) the key figure in the structure using one or more characteristic selections. The key figure, restricted by one or more characteristic selections, can be a basic key figure, a calculated key figure, or a key figure that is already restricted.

Procedure

Defining a New Selection

  1. If the query does not contain any key figure structures yet, drag a key figure to a directory in Query Designer. Alternatively, select the header of the directories for Rows or Columns and select New Structure in the context menu.
  2. Select the structure directory, and choose New Selection in the context menu. The New Selection entry is inserted, and the properties of the selection are displayed in the Properties screen area.
  3. Select the New Selection entry and choose Edit in the context menu. The Change Selection dialog box appears.
    Note

    You can also call the Change Selection dialog box from the Properties screen area by choosing Edit.

    You make the basic settings on the General tab page.

    A text field for entering a description of the selection is available in the upper part of the screen.

You can usetext variables in the description.

You can also enter a technical name in the Technical Name field.

A directory of all objects available in the InfoProvider is displayed below the text field, to the left of the Detail View area. The empty field for the definition of the new selection (Details of the Selection) is on the right-hand side of the screen.

Note

If the query contains two characteristic structures - one in the rows and one in the columns - and a key figure is defined in the filter, the key figures of the InfoProvider are not displayed on the left-hand side of the Detail View.

  1. Drag a key figure from the InfoProvider, and restrict it by selecting one or more characteristic values. SeeRestricting Characteristics.
    Note

    You can also use variables instead of characteristic values. For technical reasons, note that you cannot use the following variable types in selection structure elements:

You can use these variable types to restrict characteristics in the rows, columns, or in the filter.

Note

If a characteristic has a compound characteristic, the compound characteristic is automatically added during the drag and drop action.

For example, characteristic Country is compounded to characteristic Region. If you now drag the Region characteristic to the Details of the Selection area, the Country characteristic is also added automatically. If the Country characteristic is already in the Characteristic Restrictions for the filter, and you now drag the Region characteristic to the Details of the Selectionarea, only the Regioncharacteristic is displayed under Details of the Selection. This is because the Country characteristic is already in the Characteristic Restrictions for the filter.

  1. Make any necessary settings for the properties of the selection on the other tab pages. SeeSelection/Cell/Formula Properties
  2. Choose OK. The new selection is defined in the structure.

Editing Selections

  1. If you want to change the restriction on a key figure, select the key figure in the structure and choose Edit in the context menu. The Edit Selection dialog box appears.
    Note

    You can also call the Change Selection dialog box from the Properties screen area by choosing Edit.

  2. Make the required changes to the definition and, if required, to the properties on the corresponding tab page.
  3. Choose OK.

Marking Selections as Constant

You can mark a selection in the Query Designer as constant. This means that navigation and filtering have no effect on the selection at runtime. This allows you to easily select reference sizes that do not change at runtime.

More information:Constant Selection

Defining Properties for the Selection

  1. Select the selection in the structure. The properties dialog box is displayed in the Properties screen area.
  2. Make the required settings for the technical name, description, display, number format, and calculations for the selection. SeeSelection/Cell/Formula Properties