SSPROCROWLIMIT

Parameters

SSPROCROWLIMIT specifies the maximum number of spreadsheet rows the server processes on a user spreadsheet request.

Syntax

SSPROCROWLIMIT n

n	An integer value between 16,384 and 500,000, inclusive. The default value is 250,000.

Description

SSPROCROWLIMIT specifies the maximum number of spreadsheet rows the server processes on a user request. This value is taken before suppression; that is, it includes missing rows and rows containing zero values.

This setting enhances performance by preventing excessive memory consumption by spreadsheet operations.

Example

SSPROCROWLIMIT 300000

Notes

• SSPROCROWLIMIT applies to unprocessed rows; that is, it is the number of rows Hyperion Essbase accepts before processing. Row processing eliminates missing rows. After processing, the number of rows that the client can retrieve depends on Excel or Lotus defined limits.
• If SSPROCROWLIMIT is exceeded, Hyperion Essbase issues an error message and stops processing the request.

Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.