Defining Restricted Key Figures 

Use

You can restrict the key figures of an InfoProvider for reuse by selecting one of more characteristics. The key figures that are restricted by one or more characteristic selections can be basic key figures, calculated key figures or key figures that are already restricted.

Procedure

Defining a New Restricted Key Figure

...

       1.      In the InfoProvider objects display frame, select Key Figure and from the context menu (right-mouse click), choose New Restricted Key Figure.

If a restricted key figure has already been defined for this InfoProvider, you can also select the Restricted Key Figures entry and, from the context menu, choose New Restricted Key Figure using the right mouse button.

The New Restricted Key Figure dialog box appears.

The text field, in which you can enter a description of the restricted key figure, is found 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 defining the restricted key figure is on the right-hand side of the screen.

       2.      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 restricted key figures for technical reasons.

¡        Variables with Replacement with Query process type (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.

       3.      Choose OK.

Editing restricted key figures

Note that when you change a restricted key figure, these changes are effective in all queries that use this restricted key figure.

You can see where the restricted key figure is used. Choose Where-used List from the context menu of the restricted key figure (secondary mouse click).

...

       1.      In the InfoProvider objects display frame, select the restricted key figure and, from the context menu (right-mouse click), choose Edit.

       2.      Make the required changes.

       3.      Choose OK.

Determining properties for the restricted key figure

...

       1.      In the left display frame for InfoProvider objects, select the restricted key figure and, from the context menu, choose Properties.

       2.      Make the required settings for the description, number format and currency translation for the restricted key figure. See Restricted key figure properties

Result

You have defined a restricted key figure for reuse. You can now use this restricted key figure in all queries based on this InfoProvider by moving the key figure into the rows or columns of the query using Drag&Drop. The restricted key figure is not an actual element in this query, but a placeholder referenced to the restricted key figure in the InfoProvider.