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
- Go to Business Analytics Work Center.
- Go to Design Key Figures Work Center View.
- Click on 'New'.
- Maintain the name and select the data source in which you would like to create.
- Select > Calculated Key figure.
- 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:
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