SAP Knowledge Base Article - Public

1884963 - Value help result is restricted to 200 records in reports and dashboards

Symptom

You want to fetch all existents records using the the Value Selection for a particular characteristic, however the selection restricts the number of result displayed in that screen and shows the information message: Value help is restricted to 200 records.

 Use Case: You want to see all existents records available from the value selection for a specific object which has more than 200 records.

Environment

SAP Cloud for Customer

SAP Business ByDesign

Reproducing the Issue

In this case, the behavior for the report Balance Audit Trail, for instance, can be reproduced as follows:

  1. Go to Business Analytics Work Center and choose Design Report view.
  2. Open the Balance Audit Trail (FINGLAU11_Q0001) report.
  3. Click on the Value selection for the G/L Accounts field and choose the Basic Select tab.
  4. The list will provide a maximum of 200 records and the following information message: Value help is restricted to 200 records.

Note: You we'll be able to reproduce such behavior if the object you are selecting has more than 200 records in reports and dashboards. in Dashboards the filter behaves like the selection in the report. The message will not be shown there yet but delivered in a future release.

Cause

The system behavior is as designed.

Resolution

The value selection result is restricted to 200 records however you can show/find any additional records, out of this range, using the advanced search options or other search criteria, such as asterisk (*) to search for objects. For example *XYZ*, *XYZ etc.

Keywords

value help; restriction; 200 records; selection; restricted; report selection; report; dashboards; filter , 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