SAP Knowledge Base Article - Public

1969630 - The Key Figure Group is not Preserved in the Custom Reports

Symptom

You are creating a report by copying a SAP standard report or creating a new data source based on a SAP standard data source, however, all the original Key Figure Groups in the standard report do not get copied to the new report.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Analytics work center.
  2. Go to Design Reports view.
  3. Select the SAP standard report XYZ from which you want to copy and create a new report. (Where XYZ corresponds to report ID)
  4. Click on New button and select the option Report as Copy.
  5. On Copy Report: XYZ screen, under step 1: Define Report and Select Data Source, give the name and the description of the report.
  6. Click Next and Go to Step 2: Select Key Figures.
  7. Here in the show field, select Key Figure Group option from the drop down menu.
  8. All the Key Figure Groups will be displayed in the list.

Here, you can only select one Key Figure Group from the list.

Cause

This is designed system behavior. Each Key Figure Group is a structure delivered as part of standard data sources. Each Key Figure Group has an underlying implementation and has a 1:1 relationship with the report.

Each Structure has an exit class under parameters. If there are multiple Key Figure Groups in the report then there will be a conflict at runtime in determining which structure was involved in execution.

Please note: If the exit class is on a characteristic with 'Fixed value selection' the value help will be blank as the chosen value is hard coded.

Please note the same logic also exisits for custom data sources and custom reports.

Resolution

When creating a report as a copy of a standard report or creating a new report, make sure you always select one Key Figure Group that matters the most in your report. When you go to Step 2: Select Key Figures, click on Show and from the drop down options, select Key Figure Group .

All the Key Figure Groups will be listed down. Now choose the one which you require in the report.

If not selected the system randomly selects a Key Figure Group.

Keywords

Key Figure Groups, Custom Reports, Report, Key figure, Standard Reports, blank , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , AP-ACC , Business ByDesign: Financial Accounting , How To

Product

SAP Business ByDesign all versions