QUERYRESULTLIMIT

This Essbase configuration setting specifies the maximum number of cells returned by an MDX or grid client query. Applies to block storage, aggregate storage and hybrid aggregation databases.

Syntax

QUERYRESULTLIMIT [appname [dbname]] n

appname—Optional. Applies the query result limit to the application specified. If you specify appname, you must also specify a value for n, or Essbase ignores QUERYRESULTLIMIT. If you do not specify an application, you cannot specify a database, and the query result limit applies to all applications and databases on the server. If you specify a value for appname and do not specify a value for dbname, the query time limit applies to all databases in the specified application.

dbname—Optional. Must be used with appname and n, or the server ignores QUERYRESULTLIMIT. If you specify dbname, appname, and n, the query result limit is applied only to the specified database.

n—An integer value between 0 and 2^{^31} specifies the number of query result cells that the server allows a query to return.

The default value is 1000000 (1M).

Description

QUERYRESULTLIMIT specifies the maximum number of result cells that an MDX query or grid client query can retrieve before Essbase terminates the query and returns an error message.

Use this setting to limit the result volume of queries, and prevent a query from freezing when a very large number of result cells are returned.

Examples

QUERYRESULTLIMIT Sample Basic 100000

Sets 100,000 cells as the maximum number of results cells returned in a query to the Basic database for the Sample application.

QUERYRESULTLIMIT 150000

Sets 150,000 cells as the maximum number of cells that a query can return before being terminated. The query result limit applies to all applications and databases on the Essbase Server that corresponds to this configuration.