2579377 - Cannot use Characteristic to Create Calculated Key Figure

SAP Knowledge Base Article - Public

2579377 - Cannot use Characteristic to Create Calculated Key Figure

Symptom

You are trying to create a custom calculated key figure and you are unable to find the fields in the data source to perform the calculation.

Environment

C4C and Business ByDesign

Reproducing the Issue

1. Goto Business Analytics Work Center

2. Design Key Figures

3. Click on 'New'

4. Maintain the name and select the data source in which you would like to create

5. Select > Calculated Key figure

6. Click on Next

You will not find all the fields in the data source but it will show only the key figures available in the data source to perform calculation.

Cause

You can create calculated key figure only using the key figures available in the data source as they are quantifying values. Characteristics will not be seen in this tab calculated/restricted key figures since you cannot perform calculation on those fields.

Resolution

This is system designed behavior. You can make use of key figures available in data source to perform calculation.

If the characteristics that you want to make use in creating calculated key figures are date fields then those fields can be created as key figure from Cloud Studio by partners. Then you can be utilize those date fields for creating calculated key figure. You refer to link for the steps to be followed while creating from Cloud Studio:

 Use Date data type field as key figure in Analytics

Keywords

cannot create key figure, , KBA , missing fields to create calculated kf , cannot create key figure , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

SAP BUSINESS BYDESIGN 1802 ; SAP Business ByDesign 1711 ; SAP HYBRIS C4C 1802 ; SAP Hybris Cloud for Customer 1711