Sets the maximum number of connections per database that Essbase can keep active against the relational database.
HAMAXNUMCONNECTION [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—Specifies the number of connections per database that Essbase can keep connected to a relational database. The default is 25.
This setting determines the maximum number of connections per database that Essbase can keep active against the relational database. This optimizes the overhead involved in opening a relational database connection for every Hybrid Analysis report.
You may need to set the value for the HAMAXNUMCONNECTION higher if, in Integration Services Console, you set the security mode to use the Essbase user ID to connect to the source database. Refer to the Oracle Essbase Integration Services Online Help for more information on the security mode setting.
This setting is interpreted as 0 (zero) for Advanced Relational Analysis (ARA) because ARA does not support a connection pool.
HAMAXNUMCONNECTION 10