SSPROCROWLIMIT

Controls the maximum number of rows Essbase processes on a Smart View or other grid client request.

Syntax

SSPROCROWLIMIT n

Where n is an integer value of 16,384 or higher. The default value is 250,000.

Description

SSPROCROWLIMIT controls the maximum number of rows Essbase processes on a Smart View or other grid client user request. SSPROCROWLIMIT is in effect only for grid clients when the Suppress #Missing Rows option is selected The rows are counted before suppression; that is, missing rows and rows containing zero values are included.

When users zoom in on one or more members, Essbase must process a larger grid containing selected members expanded to the zoom-in level set in the options. When the Suppress #Missing Rows option is set, Essbase returns only rows with at least one column containing a non-missing value. SSPROCROWLIMIT defines the maximum size (number of rows) of the larger grid that Essbase needs to process. This setting prevents excessive memory usage for a single grid operation.

When the Excel Suppress #Missing Rows option is not selected, the limit is 64000.

Notes

  • SSPROCROWLIMIT applies to unprocessed rows; that is, it is the number of rows Essbase accepts before processing. Row processing eliminates missing rows. After processing, the number of rows that the client can retrieve depends on grid-client-defined limits.

  • If SSPROCROWLIMIT is exceeded, Essbase issues an error message and stops processing the request.

  • This setting is not used in the Smart View Free form mode.

  • Oracle does not recommend using a limit higher than 500,000.

Example

SSPROCROWLIMIT 300000