Symptom
From the Business Analytics you can create a new key figure either via the report wizard Design Reports-> New Report --> Select Key Figures (Step 2) or via Common Tasks -> New Key Figure.
Example 1: (Operation Income restricted Key Figure)
Step 1. (Define Key Figure and Select Data Source):
- Enter the Key Figure name (e.g. Operation Income) then choose the Data Source Name as Profitability Management.
- Choose Create a Restricted Key Figure and select the Amount Company Currency (AMTCOMP) Key Figure then click Next.
Step 2. (Restrict/Calculate Key Figure):
- Choose the Characteristic you want to use for the restriction. (e.g. Profitability Line)
- Select the desired Restriction Type. (e.g. Fixed)
- Click on the Set Fixed Value Selections Button to set your restriction on Operation Income.
- Select the desired Operation Income from the value help. (e.g. 0GREV Gross Revenue ZIA2 (Contribution Margin Scheme))
Step 3 (Properties):
- Here you can specify other calculations/conversions if any.
- Select Finish to complete the Operation Income Key Figure which is now ready to use.
Example 2: (Gross Profit % calculated Key Figure)
As preliminary step create a restricted Key figure and name it Gross Profit with the below restriction for the Profitability Line characteristic:
From the value help. (e.g. 0CMR1 Gross Profit ZIA2 (Contribution Margin Scheme))
Step 1. (Define Key Figure and Select Data Source):
- Now the calculated key figure can be created as follows.
- Enter the Key Figure name (e.g. Gross Profit %) then choose the Data Source Name as Profitability Management.
- Choose Create a Calculated Key Figure then click Next.
Step 2. (Restrict/Calculate Key Figure):
- Here you can see the newly created key figures (restricted) in the list of available key figures (e.g. Operation Income and Gross Profit).
- You can drag and drop these key figures onto the formula work space and add the operator to build your formula.
- For example: "Gross Profit"/"Operation Income"*100
Step 3 (Properties):
- Here you can specify other calculations/conversions if any.
- Select Finish to complete the Operation Income Key Figure which is now ready to use.
Environment
SAP Cloud for Customer
SAP Business By Design
Keywords
key figure, custom, restricted, calculated , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To