Controls the maximum number of spreadsheet rows Analytic Services processes on a user spreadsheet request.
SSPROCROWLIMIT n
n | An integer value between 16,384 and 500,000, inclusive.
The default value is 250,000. |
SSPROCROWLIMIT controls the maximum number of spreadsheet rows Analytic Services processes on a user request. This value is taken before suppression; that is, it includes missing rows and rows containing zero values. Note that the rows processed limit is not the same as the rows displayed limit. SSPROCROWLIMIT does not limit the number of rows displayed in the spreadsheet. The maximum number of rows that can be displayed is determined by the limits defined in Excel and Lotus. For example in 32-bit Excel, if you set the SSPROCROWLIMIT value to 20,000, the spreadsheet may still return more than 20,000 rows because in Excel the maximum number of rows that can be displayed is 64,000.
This setting enhances performance by preventing excessive memory consumption by spreadsheet operations.
SSPROCROWLIMIT 300000
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |