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³¹ specifies the number of query result cells that the server allows a query to return.

The default value is 1000000 (1M).

Description

When a query exceeds the QUERYRESULTLIMIT, 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.

QUERYRESULTLIMIT configuration applies to aggregate storage (ASO) databases and block storage (BSO) databases, including those that are in hybrid mode.

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.