Essbase Enterprise Services enables client requests to share connections, which conserves software and network resources, and improves performance. You must restart the server to reflect changes to the connection pool.
To define a connection pool:
In the navigation panel, select a domain under Domains or select Connection Pools if connection pools have already been created.
Right-click, then select Create > Connection Pool.
In the dialog that is displayed, type the name for your connection pool; for example, mypool.
Click OK.
In the navigation panel, select the connection pool that you have just created.
In the connection pool's properties panel, set the service component name for the cluster associated with the connection pool; for example, mycluster.
Enable the check box for the service component.
Enter the username and password.
Set the initital capacity, maximum capacity, capacity increment.
Specify whether to enable access for everyone.
Click Save.
Specify the connection pool name in the properties panel of the Enterprise Server for which you want to associate the connection pool.