HAMAXNUMSQLQUERY

Sets the maximum number of SQL queries that can be issued against the fact table(s) in the relational database per Analytic Services query session.

Syntax

HAMAXNUMSQLQUERY [appname [dbname]] n

 appname Optional parameter. If you supply an application name, the setting applies to all databases within the named application. If you do not supply an application name, the setting applies to all applications and databases on the Analytic Server.
 dbname Optional parameter. If you supply a database name and an application name, the setting applies only to the named database. If you do not also provide an application name, the database is ignored and the setting applies to all applications and databases on the Analytic Server.
n The value of n is the number of simultaneous SQL queries per Analytic Services query session. The default is 50.

Description

This setting determines the maximum number of SQL queries that can be executed during an Analytic Services query session from Report Writer or from the Spreadsheet Add-in extractor. If a query cannot be split into pieces in such a way as to not violate the limits set by this command, the query execution fails. The user has to submit a smaller version of the query, or the administrator must raise the value of this setting. HAMAXNUMSQLQUERY does not refer to the number of users performing queries; rather, it refers to the number of SQL queries in a complex statement.

Example

In the following example, the maximum number of SQL queries per Analytic Services query session is set to 10.

HAMAXNUMSQLQUERY 10

See Also

HAMAXQUERYROWS
HARETRIEVENUMROW
QRYGOVEXECBLK
QRYGOVEXECTIME

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com