SAP Knowledge Base Article - Public

2882412 - Error Message When Using Report Value Help

Symptom

 Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

You created a custom data source and you are trying to select a value for the 'XYZ' characteristic using the Value Help via Report Wizard or Selection tab on report. It keeps loading until 'Report cannot be opened; Report an incident' or 'An Exeption Occured' messages are experienced.

Environment

  • SAP Cloud for Customer
  • SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Analytics work center.
  2. Go to the Design Data Sources view.
  3. Search for a custom data source (e.g XYZ).
  4. Click on the Value Help for 'XYZ' characteristic.
  5. It keeps loading and no value appears to be selected.
  6. You can see the error message 'Report cannot be opened; report an incident' message.

or

  1. Go to the Business Analytics work center.
  2. Go to the Design Reports view.
  3. Click on New.
  4. Select the custom data source (e.g XYZ).
  5. Go to Step 4.
  6. Select 'Fixed Value Selection' for 'XYZ' characteristic.
  7. Click on 'Set Fixed Value Selection'.
  8. Click on Value Help for 'XYZ' characteristic. 
  9. You can see an error message 'An Exception Occured'

Cause

This can happen when the custom data source is a joined data source and it has a high amount of records. When the Value Help is of 'Use Context'  and it is opened for any characteristic, the system needs to apply the join condition initially and then it will bring the entries to be selected in the Value Help.  In this case the Value Help does not bring any value because the data source has too many records to be joined before shows it on the Value Help for further selections. It is is due to a time out error in the backend process which occurs whenever the processed amount of data is too high.

Resolution

In order to filter on the characteristic 'XYZ' which cannot be selected via Value Help, you can just type the desired value for the characteristic under the 'Selection' tab on the report (without using Value Help). Please see the screenshot below where we just wrote the desired value and the system filtered accordingly on the report.

KBA.png

And for the second case, when using the Report Wizard, in order to set a 'Fixed Value Selection' for the 'XYZ' characteristic you can just click on the 'Set Fixed Value Selection' and write the desired value (without using Value Help). Please see the both screenshot below where we just wrote the desired value and the system interpreted it:

KBA1.png

KBA3.png

See Also

 2277591 - Value Help Types: Use Context and Use Master Data

1926357 - Error Message When Running Report: Report Cannot be Opened / Failed to Open Report; Report an Incident

2366796 - Best Practices for Modelling and Handling Data Sources and Reports - Performance

Keywords

selection timeout; timeout; report cannot be opened; report an incident; selection empty; value help empty; value help loading; selection loading; value help timeout; selection timeout; an exception occured; , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer core applications all versions