Creating Restricted Key Figures

Objectives

After completing this lesson, you will be able to:

  • Create a query with restricted key figures

Restricted Key Figures

Restricted key figures are key figures of the InfoProvider that are restricted by one or more characteristic values.

For example: sales quantity(key figure) for Finland, 2023(characteristic values). A restricted key figure may be based on a basic key figure, a calculated key figure, or a key figure that is already restricted.

By using restricted key figures, you can focus the query result on certain values. A query filter is valid for an entire query but a restricted key figure is valid only for the key figure, restricting it to its allocated characteristic value or characteristic value interval.

Restricted key figures are often used to compare multiple key figures for various time segments, or to compare plan versus actual. In these cases, the same key figure is used in the definitions but different characteristic values create new versions of the figures.

You can create restricted key figures at the query-level and at the InfoProvider level. InfoProvider-level restricted key figures can be reused across many queries.

Restricted Key Figures at the Query Level

There are multiple ways to create a restricted key figure at the query level. These include the following:

  • Drag the key figure to be restricted into an existing key figure structure in the Rows or Columns section, and edit the key figure.

  • Right-click the heading or any member of the structure to open the context menu, and choose Add Key Figures, and edit the key figure.

  • Right-click the heading or any member of the structure to open the context menu, and choose New Selection, and edit the selection.

  • If there isn’t yet a key figure structure, you can drag the key figure to be restricted to the Rows or Columns section, a key figure structure will be generated automatically, which you can edit.

    Alternatively, right-click in the Rows or Columns section, and choose Add Key Figures, a key figure structure will be generated automatically, which you can edit.

  • You can also begin with creating the key figure structure: right-click in the Rows or Columns section, choose New Structure, choose New Selection, and edit the selection.

How to Define Restricted Key Figures at Query Level

Launch the following demo to learn how to define restricted key figures at query level.

Restricted Key Figures at InfoProvider Level (Reusable Component)

When you create a restricted key figure at the InfoProvider level, you can reuse it in all queries that are based on the same InfoProvider.

To define a restricted key figure at the InfoProvider level:

  • In the InfoProvider tab on the left of the Query Designer, right-click the folder Restricted Key Figure in the Reusable Components folder to open the context menu.

  • Choose New Restricted Key Figure and edit the selection.

  • Alternatively, in the BW Repository in Project Explorer tab, you can right-click the InfoProvider and select NewRestricted Key Figure.

  • You must drag the restricted key figure to the section where it should be used because it is not automatically included in your query.

  • You can reuse the restricted key figure in all queries that are based on the same InfoProvider.

  • Changes made later to the restricted key figure affect all queries in which it is used.

  • You cannot Dereference the reused restricted key figure.

How to Define Reusable Restricted Key Figures at InfoProvider Level

Launch the following demo to learn how to define reusable restricted key figures at InfoProvider level.

Log in to track your progress & complete quizzes