How To Definine a New Restricted Key Figure

Restricted Key figures:
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.

Calculated key Figure:
Calculated key figures consist of formula definitions containing basic key figures, restricted key figures or precalculated key figures.

Procedure for Defining a new restricted key figure:

1. 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 then choose New Restricted Key Figure from the context menu.

The entry New Restricted Key Figure is inserted and the properties for the restricted key figure are displayed in the Properties screen area.

2. Select the New Restricted Key Figure entry and choose Edit from the context menu (secondary mouse button).

  • The Change Restricted Key Figure dialog box appears.
  • 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, 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 (see Using Text Variables).
  • Next to that, you can enter a technical name in the Technical Name field.
  • Underneath the text field, to the left of the Detail View area, the directory of all objects available in the InfoProvider is displayed. The empty field for defining the restricted key figure (Details of the Selection) is on the right-hand side of the screen.
3. Using drag and 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 instead of characteristic values. However, note that you cannot use the following variable types in restricted key figures for technical reasons:

  • Variables with the process type Replacement with Query (see also Replacement Path: Replacement with Querys)
  • 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.

4. Make any necessary settings for the properties of the restricted key figure on the other tab pages. See Selection/Formula Propertiess.

5. Choose OK. The new restricted key figure is defined for the InfoProvider.

Get help for your SAP BW problems
SAP BW Forum - Do you have a SAP BW Question?

SAP BW Books
SAP Business Warehouse Certification, Interview Questions and Configuration Reference Books

SAP BW Tips
SAP BW Tips and Business Information Warehouse Discussion Forum

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.sap-img.com

All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.sap-img.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.sap-img.com or the content authors.