Controls the maximum number of spreadsheet rows Essbase processes on a Spreadsheet Add-in request.
SSPROCROWLIMIT n
Where n is an integer value of 16,384 or higher. The default value is 250,000.
SSPROCROWLIMIT controls the maximum number of spreadsheet rows Essbase processes on a Spreadsheet Add-in user request. SSPROCROWLIMIT is in effect only for Spreadsheet Add-in 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, Analysis Services 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 Spreadsheet Add-in operation.
When the Excel Suppress #Missing Rows option is not selected, the limit is 64000.
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 spreadsheet-defined limits.
If SSPROCROWLIMIT is exceeded, Essbase issues an error message and stops processing the request.
If using Advanced Interpretation mode in the Spreadsheet Add-in, one cannot turn this setting off from the spreadsheet. The setting is not used in Freeform mode.
It is not recommended to use a limit higher than 500,000.
SSPROCROWLIMIT 300000