SAP Knowledge Base Article - Public

2618797 - Error During KPI Creation: Report XYZ cannot be used (based on key figure grid)

Symptom

You are creating a KPI, however on saving you get the following error message:

'Report XYZ (XYZ stands for the report that your KPI is based on) cannot be used (based on key figure grid)'

Environment

  • SAP Business ByDesign
  • SAP Hybris Cloud for Customer

Reproducing the Issue

  1. Go to the work center Business Analytics.
  2. Select the view Design KPIs.
  3. Click on New.
  4. In the Report Name, select the desired report; for example, Headcount and FTE: Quarterly.
  5. Select any key figure and selection.
  6. Fill in the other mandatory entries.
  7. Click on Check (or Save).

Cause

The report you selected contains a key figure grid. The purpose of a key figure grid is to report key figure structures and characteristics structures in 2 axis. In a KPI however, it is not possible to use 2 axis and hence such reports cannot be supported for the creation of KPIs.

Resolution

You can create a report copy, remove the key figure grid and select the key figures to be used separately. Then you will be able to use your report copy for your KPI. The steps to do so are:

  1. Go to the Business Analytics work center, view Design Reports.
  2. Search for the report you want to use for your KPI.
  3. Click on New > Report as Copy.
  4. Enter a report name and click on Next.
  5. In step 2, you will see a key figure group that is automatically selected. Expand it and take note of the key figures that are part of this group.
  6. Now de-select the key figure group and select the key figures separately instead.
  7. Go through the other settings and adjust them if necessary. For example, if you are copying a Headcount and FTE report and have removed the time series, you would need to select the characteristic Key Date in step 3.
  8. Finish your report copy and assign it.
  9. Now go back to the Design KPI work center view and create your KPI based on the report copy. 

See Also

1701636 - How to make the Time Series variable for Employee Times or Time Accounts reports?

Keywords

Create KPI, key figure grid, report cannot be used , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

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