Skip to Content
Former Member
Sep 17, 2009 at 05:32 AM

Result set too large in BI report; Safety belt settings in WAD


Hello All,

When we run a BI report, the error " Result set is too large; data retrieval restricted by configuration" appears. We did a search on SAP portal and found the SAP note 1127156, whics recommends the configuaration of safety belt to limit memory used.

Acoordingly the cust table RSADMIN has been configured. But on the web template side, we need to configure the changes as well. The note says:

"1. Use the context menu Properties / Data Provider in a BEx Web Application to maintain the "safety belt" for a Query View.

2. Choose the register "Size Restriction for Result Sets".

3. Choose an entry from the dropdown box to specify the maximum number of cells for the result set.

The following values are available:

Maximum Number

Default Number

Custom-Defined Number

Behind "Maximum Number" and "Default Number" you can find the current numbers defined in the customizing table RSADMIN (see below).

4. Save the Query View and use it in another Web Template."

I am trying to locate these options in the context menu in Web Applications designer but in vain.

Can anyone help...