Defining Selections 

Use

You can define a query by using Drag&Drop to drag the key figure of the InfoProvider into the Query Designer directories. If you move 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 that is 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 yet have any key figure structures, use Drag&Drop to drag a key figure into a directory of the Query Designer. Alternatively, select the header of the directories Rows or Columns and, using the secondary mouse button, select New Structure from the context menu.

       2.      Select the structure directory, and, using the secondary mouse button, choose New Selection from the context menu. The New Selection entry is inserted and the properties for the selection are displayed in the Properties screen area.

       3.      Select the New Selection entry and, from the context menu (secondary mouse button), choose Edit. The Change Selection dialog box appears.

Make the basic settings on the General tab page.

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

You can use text variables in the description.

Next to that, you can enter a technical name in the Technical Name field.

Underneath the text field, on the left of the Detail View, is the directory of all the objects available in the InfoProvider. The empty field for the definition of the new selection is on the right-hand side of the screen: Details of the Selection.

       4.      Use Drag&Drop to choose a key figure from the InfoProvider, and restrict it by selecting one or more characteristic values. See Restricting Characteristics.

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

○     Variables with the process type Replacement with Query (see also Replacement Path: Replacement with Query)

○     Variables that represent a precalculated value set (see also Details).

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

       5.      Make any necessary settings for the properties of the selection on the other tab pages. See Selection/Formula Properties.

       6.      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 from the context menu (secondary mouse button). The Edit Selection dialog box appears.

       2.      Make the required changes to the definition and, if required, in the properties on the associated 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.

For more information, see Selecting Constants.

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 in the selection. See Selection/Formula Properties.