Symptom
- An error is received when refreshing reports
- Error: 'com.businessobjects.mds.olap.protocol.bics.BICSException: Number of members (x) exceeds 5,000 ; please do a search by element instead. Number of members (x) exceeds 5,000 ; please do a search by element instead'
Environment
- Crystal Reports for Enterprise 4.0 SP05 or higher
- BW 7.x
Reproducing the Issue
-
From Crystal Reports for Enterprise, create a new report against a BW query. The BW query should contain a variable which would prompt for more than 5000 records
-
Refresh the report
Cause
A limit of 5000 records has been introduced with SP5 for BI 4.0 to avoid memory consumption issues
Resolution
- Locate file Config.ini file located at <INSTALLATION_DIR>\Program Files (x86)\SAP BusinessObjects\Crystal Reports for Enterprise XI 4.0\configuration
- Add the following line to the file: sap.sl.bics.bicslovlimit=xxxxx where xxxxx is the number of records to display
- For instance to extend the limit to 20000 the line should be sap.sl.bics.bicslovlimit=20000
- Save the Config.ini file
Keywords
KBA , BI-RA-CR-DES , Crystal Reports Designer (CR20XX) , Problem
Product
Crystal Reports for Java all versions