Show TOC

Defining Restricted Key FiguresLocate this document in the navigation structure

You can restrict the key figures of an InfoProvider by 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. A restricted key figure is reusable

Procedure

  1. Open the context menu for the InfoProvider and choose Start of the navigation path New Next navigation step Restricted Key Figure End of the navigation path. The New Restricted Key Figure wizard opens. The system applies the properties from the BW project and the InfoProvider, which the project is based on, as the default settings.
  2. Enter a description and a technical name for the restricted key figure.
  3. In the Key Figure field, you can enter the Key Figure of the InfoProvider. Choose Browse. A dialog box appears where you can select an object. (You can also leave this blank and create the selection in the editor).
  4. If you have created a directory structure for your reusable objects in the component hierarchy maintenance screen (transaction code RSZTREE), you can enter the required folder in field Folder. Choose Browse. A dialog box appears where you can select an object. (You can also leave this blank. Then the system displays the calculated key figure in folder Start of the navigation path Reusable Components Next navigation step Restricted Key Figures End of the navigation path).
  5. You have now configured the basic settings. Choose Finish to create the restricted key figure. The editor appears.
  6. On the General tab, you can configure the required restrictions in the Selection area. To do this, drag and drop the required key figure of the InfoProvider into the selection area and restrict the key figure by selecting one or more characteristic values.
    Note

    You can also use variables instead of characteristic values. Note that, due to technical reasons, you cannot use variables with processing type Replacement Path with replacement from a query in restricted key figures.

  7. Change the settings as required for the properties of the restricted key figure in the Properties screen area.

    The Properties screen area contains the following tabs, which correspond to the properties of a selection:

    • General tab: For calculated key figures, the same properties are available in the Constant Selection and Display screen areas as are available for the properties of a selection. The only difference is that the Selection screen area is not available because the calculated key figure cannot be changed in the query.

    • Conversion tab

    • Calculation tab

  8. Select the restricted key figure.

Results

You have created a restricted key figure for an InfoProvider. This key figure can be reused in queries, which are based on this InfoProvider. The restricted key figure is not an actual element in this query. It is a placeholder that references the restricted key figure created for the InfoProvider.

You can find the restricted key figure either in the BW Repository of the query under the Start of the navigation path Reusable Components Next navigation step Restricted Key Figures End of the navigation path, or by using the search. To search for the key figure, find the toolbar in the BW Modeling perspective and choose Search (Search). Now you can search for the query on the BW Object Search tab. In the Advanced Filter area, you can restrict the search to the type ELEM [Query Element] and subtype RKF [Restricted Key Figure] .