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 itself 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, drag a key figure using Drag&Drop into a directory of the Query Designer. Alternatively, select the header of the directories for 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 screen appears.

There is a text field, in which you enter a description of the selection in the upper part of the screen.

You can use Text Variables in the description.

Underneath the text field, on the left, 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.

       3.      Using Drag&Drop, 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 the characteristic values. However, note that you cannot use the following variable types in selection structure elements for technical reasons.

¡        Variables with the replacement with query processing type (see also Replacement Path: Replacement with Query)

¡        Variables that represent a precalculated value set (see also Detail Statements)

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

       4.      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 from the context menu (secondary mouse click), choose Edit. The Edit Selection dialog box appears.

       2.      Make the required changes.

       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 for the runtime. In this way, you can easily select reference sizes that you cannot change for the rest of  the runtime.

For more information, see Selecting Constants.

Defining properties for the selection

...

       1.      Highlight the selection in the structure and, from the context menu, choose Properties.

       2.      Make the required settings for the technical name, description, display, number format, and calculations in the selection.  See Selection/Formula Properties