HAMAXQUERYTIME

Sets the maximum time limit per query for SQL queries from a Hybrid Analysis Relational Source. When set on a Oracle datasource, this setting is ignored and a warning message is logged in the application log file.

Syntax

HAMAXQUERYTIME [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 determines the time limit per query in seconds. The default is zero, meaning that no time limit is applied.

Description

This setting determines how much time an SQL query operation can take before it is forcefully terminated. HAMAXQUERYTIME is a specific limit to an Analytic Services query that spans the Hybrid Analysis Relational Source and is set in the essbase.cfg file. The value set is dependent on how long an SQL query issued on behalf of an Analytic Services query can take to complete.

An important distinction exists between the purposes of HAMAXQUERYTIME and QRYGOVEXECTIME. Note that QRYGOVEXECTIME affects the entire query, such as from the time a user double-clicks a cell to retrieve data in Spreadsheet Add-in to the time the results are displayed. HAMAXQUERYTIME, on the other hand, affects only a portion of the Analytic Services query, such as the individual SQL queries from the Hybrid Analysis Relational Source. When a query spans Hybrid Analysis data, QRYGOVEXECTIME is disabled for the rest of the overall query, and the query timer controlled by HAMAXQUERYTIME takes effect.

Example

HAMAXQUERYTIME 300

See Also

HAMAXNUMSQLQUERY
HARETRIEVENUMROW
QRYGOVEXECBLK
QRYGOVEXECTIME

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