Sets the maximum number of SQL queries that can be issued against the fact table(s) in the relational database per Essbase query session.
HAMAXNUMSQLQUERY [appname [dbname]] n
appname—Optional. 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 Essbase Server.
dbname—Optional. 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 Essbase Server.
n—The value of n is the number of simultaneous SQL queries per Essbase query session. The default is 50.
This setting determines the maximum number of SQL queries that can be executed during an Essbase 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.
In the following example, the maximum number of SQL queries per Essbase query session is set to 10.
HAMAXNUMSQLQUERY 10