Symptom
- Error when refreshing a report based on a BEx Query.
- Can successfully refresh the same report with different parameter values.
- When refreshing a report based on an SAP BW Bex Query in Crystal Reports for Enterprise, it fails with the error:
"Failed to execute query:
‘com.businessobjects.mds.olap.protocol.bics.BICSException: BW System <SAP BW System>:
Result set too large (<Number> cells); data retrieval restricted by configuration (maximum = <Maximum Number> cells)’
Redesign your query or contact the data source maintainer to solve the problem.
Please take one of the following actions:
- Click here to verify data source to fix this error.
- Click here to use ‘set data source location’ to fix this error."
Read more...
Environment
- SAP Crystal Reports for Enterprise 4.1
- SAP Crystal Reports for Enterprise 4.2
- SAP Crystal Reports for Enterprise 4.3
- SAP BW 7.4
- SAP BW 7.5
Product
SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020
Keywords
CR4E, CRFE, CRforE, CR for Ent , KBA , BI-RA-CRE , Crystal Reports for Enterprise , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.