SAP BO Analysis for Office generates “Size Limit of Result Set Exceeded”error message
At a current customer, where a transition from BW 7.x towards BW7.4 on HANA is being executed, the above error occurs when using SAP BO Analysis for Office on large datasets. To overcome this showstopper one of “my” teammembers, Dhiraj Thakur , sacrified his weekend to come up with a solution which I’d like to share with all of you via this blog.
The default size limit for SAP BO Analysis Office is 500.000 Cells. This limit generates the previously mentioned error message as soon as the number of cells exceeds the this threshold value.
To overcome this error, the size limit can be set to a higher value; Either on individual client PC and/or on BW Server side.
Option1: Increasing the size limit on a client PC (on which Analysis for Office is installed.)
Open an MsDOS box and alter a windows registry parameter by executing the following ‘code’:
REG ADD HKCU\SOFTWARE\SAP\AdvancedAnalysis\Settings\DataSource /v ResultSetSizeLimit /t REG_SZ /d 9000000
The above ‘code’ will increase the registry parameter to 9.000.000 cells.
Option 2: Increase the size limit within SAP BW
The current size limit of the BW system can be shown and is maintained via table RSADMIN. Within this table the parameter BICS_DA_RESULT_SET_LIMIT_DEF contains the current size limit. To increase this limit, ABAP program SAP_RSADMIN_MAINTAIN can be executed to view (and maintain) parameter BICS_DA_RESULT_SET_LIMIT_DEF. The value which will be chosen for this parameter will be (centrally) used for all users which logon to the BW system.
In order to use the above RSADMIN setting in the BW System, the (local) client PC registry parameter ResultSetSizeLimit should be set to -1.
To achieve this, the following command needs to be executed (as to be seen at option 1) within the MsDos box:
REG ADD HKCU\SOFTWARE\SAP\AdvancedAnalysis\Settings\DataSource /v ResultSetSizeLimit /t REG_SZ /d -1