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

[Former Member]

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...

[Former Member · Accepted solution]

This option is not available in WAD, it will be available when you run the web template under settings, Data Provider for the standard template 0ANALYSIS_PATTERN.

If you have a custom template you will have to use the Dataprovider settings web item in your custom template to change the values during runtime.

[Former Member · Accepted solution]

Hi,

When you said "Dataprovider settings web item" did you mean Web item - Dataprovider - Information. And can you please elaborate on how I can set the Custom defined number using this web item.

Thanks,

Kal