Setting the Size Restriction for Result Sets 

Use

You can specify the maximum size of the result set that a user can request. This allows you to avoid result sets that are too large and that can have a negative impact on the performance and quality of Web applications. You can use a report to do this.

Integration

You can activate the size restriction for the result set globally using a standard ABAP report. To do this, run the ABAP report by entering SAP_RSADMIN_MAINTAIN as the name.

For individual query views, you can activate the size restriction for the result set yourself when executing them in the Web Application.

Features

The default setting for the result set in Web applications is 500,000 cells. If the result set exceeds the size set in the report, the user receives a warning message from the system, and processing is terminated.

Activities

Activate Size Restriction Globally

...

       1.      On the SAP Easy Access screen, choose System → Services → Reporting (transaction SA38).

       2.      In the program field, enter the report name SAP_RSADMIN_MAINTAINand choose Execute.

       3.      For OBJECT, enter one of the parameters below. For VALUE, enter the value for the size of the result set, and then execute the program:

○       BICS_DA_RESULT_SET_LIMIT_DEF

Use parameter BICS_DA_RESULT_SET_LIMIT_DEF to set the standard size restriction for the result set for all queries and query views. The recommended setting is 500,000 cells.

○       BICS_DA_RESULT_SET_LIMIT_MAX

Use parameter BICS_DA_RESULT_SET_LIMIT_MAX to set the maximum size restriction of the result set that can be entered manually by a user for a given query view (see below).

The maximum number of cells is checked via Remote Function Call (RFC] if the cells are transported from ABAP to Java. Before this data transfer starts, the maximum number of cells is checked.

The number of cells to be transferred from ABAP to Java can be larger than the number of visible cells. You can view the number of cells transferred using the BI Query runtime statistics. The event ID counter 3200 contains the number of cells.

Further information: Displaying BI Query Runtime Statistics on the Web

The number of cells is the number of data cells (= result set of the numbers without texts and keys). The number of data cells is not the same as the number of cells in a table (visible cells in a HTML table). The number of cells in a table is larger than the number of data cells, as the table also displays cells for row and column headers, as well as rows for texts and keys of characteristics and attributes.

Data cells are cells that contain numbers. Data cells are independent of how the data is actually displayed. Data cells are therefore used as the unit of measurement for measuring the size restriction.

Activate Size Restriction for an Individual Query View

...

       1.      Call a Web application that has a query view as data provider. The query view is displayed using Web item Table.

       2.      In the Web application context menu, choose Properties → Data Provider.

       3.      Select the Size Restriction for Result Sets tab.

       4.      To set the maximum number of cells for the result set, select an entry from the dropdown box:

○       Maximum Number (…)

The number in brackets after Maximum Number is the same as the settings in parameter BICS_DA_RESULT_SET_LIMIT_MAX that was set in report RS_ADMIN_MAINTAIN (see above).

○       Standard Number (…)

The number in brackets after Standard Number is the same as the settings in parameter BICS_DA_RESULT_SET_LIMIT_DEF that were set in report RS_ADMIN_MAINTAIN.

○       User-Defined Number of Cells

With the user-defined number of cells, you can set the result set for a specific query view. If the user-defined number of cells exceeds the maximum number, the maximum number is automatically taken as the user-defined number of cells.

       5.      Save the Query View and run it in a different Web application.