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
Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies. The site www.erpgreat.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.erpgreat.com or the content authors.
|