SAP Knowledge Base Article - Public

1859568 - Error While Adding Key Figure to the Report

Symptom

You create a calculated key figure but cannot add this key figure to a report. You receive a dump or error message when editing the report and adding the key figure.

Environment

  • SAP Business ByDesign
  • SAP Cloud for Customer

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 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 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-.

Other errors are possible.

Cause

This report reached the maximum members of 1000 components. An example of a report component would be a key figure, a formula step, a restriction of a selection variable etc.

In most cases, such a scenario occurs when you create very complex key figures. For example: You create a calculated key figure whose calculation uses 10 more custom key figures. If you check each of these 10 key figures, they in turn are calculations, using other custom key figures etc.

The setup of your key figure can be 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 the customer created key figure and click the Edit button.
  4. On the next screen, click 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 components per report. Please make use of one or more of the following options:

  • You can split the report in two or more reports and distribute the key figures between the sub-reports.
  • Check if all key figures added to the report are actually required. Remove all unnecessary elements.
  • Check the modeling of each of the used key figures. Is the modeling as brief and simple as possible? Remove all unnecessary steps / elements / calculations.
  • In scenarios with multiple restricted key figures, where the base key figure is the same and the restriction is different, please also consider creating 1 key figure with a variable restriction. You will be able to set the restriction in the report selection. This eliminates the need for several key figures.

Keywords

report, key figure, 1000, key figure limit, exception, MESSAGE_TYPE_X_TEXT, CX_FATAL_EXCEPTION, dump, error message, crash, SAPLRRI2, CHECK_MAX_MEMMERS-01 , KBA , 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