Defining Selections

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

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.
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.
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.

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:
- Variables with processing type Replacement with Query (more information:Replacement Path: Replacement from Query)
- Variables that represent a precalculated value set (more information:Details)

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

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

Editing Selections

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.
Make the required changes to the definition and, if required, to the properties on the corresponding tab page.
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

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