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

  • SAP Cloud for Customer
  • SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Analytics Work Center.
  2. Go to Design Key Figures Work Center View.
  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.
  7. 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 , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions