SAP Knowledge Base Article - Public

2598645 - When logging in into a system a message shows up: Result was restricted on datasource level - more than x records

Symptom

You open the Home work center, however the system shows the error message 'Result was restricted on datasource level - more than 260.000 records'.

You open the Business Analytics work center, however the system shows the error message 'Result was restricted on datasource level - more than x records'.

Environment

  • SAP Cloud for Customer
  • SAP Business ByDesign

Reproducing the Issue

  1. Logon to your system.
  2. Go to the work center Home.

Error appears 'Result was restricted on datasource level - more than 260.000 records'

Please note that the error might also appear in other work centers or with different amount of records.

Cause

All reports and tiles on the Home page will be executed as soon you open the page. If there is too much data in one of the reports you get the error message.

Resolution

1. Home work center:

You need to identify the tile or report which has a high data volume and check if using a selection can reduce the data.

2. Business Analytics work center:

You can unlimit the data in the report table setting by unticking 'Limit Data'.

Keywords

restricted, data source, 260.000, report an case, datasource level, Limit Data, home, business analytics, more than records, ByD, C4C, , KBA , data source 250.000 , 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