MDXQRYGOVCOUNT
The MDXQRYGOVCOUNT configuration setting enables you to control how often Essbase checks for conditions that would warrant termination of an MDX query.
Use MDXQRYGOVCOUNT to reduce or increase the default number of MDX query checks. 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 the MDXQRYGOVCOUNT setting. If do not specify appname or dbname, the counter applies to the entire Essbase 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 the MaxL client.
Example
MDXQRYGOVCOUNT 1500