Key Figure Manager is used against an SAP BW data source only. A key figure is a dimension contained in every SAP BW cube. Financial Reporting allows the creation of two additional types of key figures: calculated and restricted. Using Key Figure Manager, you can create calculated and restricted key figures. The Calculated and Restricted key figures created in the Key Figure Manager become additional members for the SAP BW key figure dimensions within the Select Members dialog in Reporting Studio; calculated key figures are contained in the Calculated Key Figure folder and restricted key figures are shown in the Restricted Key Figure folder. The report designer can use those key figures in place of or in addition to the SAP BW defined key figure members to return more definitive values in a report:
Calculated — You can recalculate the key figures for use in Financial Reporting using formulas. Calculated key figures consist of formula definitions containing basic key figures. You can create a calculated key figure based on a key figure or any functions listed in the Key Figure Manager.
Restricted — Restricted are key figures of the cube that are filtered by one or more dimension member selections, and are needed in order to define a detailed report. By using restricted key figures, you can focus the query result on certain values.
New Calculated and Restricted key figures are stored in Key Figure Manager and are available for use in Member Selection. You can now use the calculated and restricted key figures in your Reporting Studio.
To define a new calculated key figure:
Navigate to the Key Figure Manager by selecting Tools, then Manage Key Figures.
In Key Figure Manager, select a SAP BW data source, then click New Calculated.
Note:
You may be prompted to enter a database connection.
In Calculated Key Figure Name, enter a name for the calculated key figure you are creating.
In the Add Function container, select Key Figure and/or a function, then click Add.
Note:
When you select a function, your calculation is based on a dimension other than Key Figure. For functions, the Formula dialog box is displayed where you select the Dimension and Measures fields.
in Member Selection, select a Member for your formula and click OK. The member is entered into the Formula text box in Calculated Key Figure dialog box.
In Calculated Key Figure, define the variable and values for your formula by using the Add Literals keypad.
Click OK to accept the formula. The Calculated Key Figure information is stored in Key Figure Manager and is added to Select Members for a SAP BW data source in Reporting Studio.
Note:
An error message is displayed for an invalid formula.
To define a new Restricted key figure:
Navigate to the Key Figure Manager by selecting Tools, then Manage Key Figures.
The Key Figure Manager dialog is displayed where, in addition to New Restricted, you can select New Calculated, Edit, or Delete a calculated or restricted key figure.
Note:
The Key Figure Name cannot be edited.
In Key Figure Manager, select a SAP BW data source, then click New Restricted.
Note:
You may be prompted to enter a database connection.
In Restricted Key Figure Name, enter a name for the restricted key figure you are creating.
In the Dimension container, select Key Figure, then select click
to select a key figure member.Optional. in the Dimension container, select a Dimension, then click
to select members for which you want to display members. To select another dimension members, repeat this step.Click OK to accept the restricted key figure information. The Restricted Key Figure information is stored in Key Figure Manager and is added to Select Members for a SAP BW data source in Reporting Studio.