1859568 - Error While Adding Calculated Key Figure to the Report

SAP Knowledge Base Article - Public

1859568 - Error While Adding Calculated Key Figure to the Report

Symptom

You create a calculated key figure but cannot add this key figure to a report.

Reproducing the Issue

  1. Go to the Business Analytics work center, view Design Reports.
  2. Open your custom report by clicking on Edit with > Report Wizard.
  3. Go to the Select Key Figures tab and click on the Create button.
  4. On the next screen, provide the name and description of your key figure.
  5. By default, Calculated Key Figure will be selected.
  6. Click on the Next button and maintain a formula here. Complete the key figure.
  7. Go back to the Select Key Figures tab in the report wizard and add the key figure you have just created to the report.

You will see an error message, such as: 

System error in program SAPLRRI2 and form CHECK_MAX_MEMMERS-01-.

Cause

This report already reached the maximum members of a key figure structure of 1000.

This can checked by following these steps:

  1. Open the report in the report wizard as above.
  2. Go to the Select Key Figures tab.
  3. Select customer created key figure and click on Edit button.
  4. On the next screen, click on the Next button and count the key figures used in the formula.
  5. Repeat the same for all the key figure structures for both calculated and restricted key figures.

Resolution

It is not possible to have more than 1000 key figure structures per report. You can split the report in two or more reports and distribute the key figures between the sub-reports.

Keywords

KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions ; SAP Hybris Cloud for Customer all versions