MDXQRYGOVCOUNT

This Essbase configuration setting initializes a counter (number of check conditions) to control how often Essbase checks for conditions that would warrant termination of an MDX query.

Using this counter can reduce or increase the default number of checks (1000); reducing the number of checks (by setting n higher) improves performance. The counter starts at n and decrements until the counter reaches zero: at that time Essbase performs a check.

Syntax

MDXQRYGOVCOUNT [appname [dbname]] n

appname—Optional. Specifies the application for which to apply the checking counter. If you specify a value for appname and do not specify a value for dbname, the setting applies to all databases in the specified application. To enable the setting for a specific database, you must specify an application and database.
dbname—Optional. Specifies the database, in the application specified by appname, for which to apply the checking counter. If you specify a value for dbname but do not specify a value for appname, your specification is ignored.
n—Integer specifying the counter (number of check conditions) that Essbase checks for conditions that warrant query termination. You must specify this parameter or Essbase ignores this setting. If do not specify appname or dbname, the counter applies to the entire server. The default value is 1000. The minimum value is 100, and the maximum value is 5000.

Note:

You can use the Esc key to cancel any query running from MaxL Shell.

Example

MDXQRYGOVCOUNT 1500