Defining Restricted Key Figures

Use

You can restrict the key figures of an InfoProvider for reuse by selecting one or more characteristics. 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 restricted key figure

In the InfoProvider screen area, select the Key Figures entry and choose New Restricted Key Figure from the context menu (secondary mouse button).
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 entry New Restricted Key Figure is inserted and the properties for the restricted key figure are displayed in the Properties screen area.
Select the New Restricted Key Figureentry and choose Edit from the context menu.
The Change Restricted Key Figure dialog box appears.

Note

You can also call the Change Restricted Key Figure dialog box from the Properties screen area by choosing the Edit pushbutton.

You make the basic settings on the General tab page.

The text field, where you can enter a description of the restricted key figure, is located in the upper part of the screen.

Note

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 defining the restricted key figure (Details of the Selection) is on the right-hand side of the screen.
Using drag and drop, choose 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. However, note that you cannot use the following variable types in restricted key figures for technical reasons:
- 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 restricted key figure on the other tab pages. SeeSelection/Cell/Formula Properties
Choose OK. The new restricted key figure is defined for the InfoProvider.

Editing restricted key figures

In the InfoProvider screen area, select the restricted key figure and choose Edit from the context menu.

Note

You can also call the Change Restricted Key Figure dialog box from the Properties screen area by choosing the Edit pushbutton.
Make the required changes to the definition and, if required, to the properties on the corresponding tab page.
Choose OK.

Determining properties for the restricted key figure

Select the restricted key figure. The properties dialog box is displayed in the Properties screen area.
Make the required settings for the description, number format, and currency translation for the restricted key figure. SeeSelection/Cell/Formula 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 and 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.