When you create a database connection, it is appended to the list in the Database Manager dialog box.
To add a database connection:
1. In Workspace, select Tools, then Database Connection Manager.
2. Click New.
3. In Database Connection Name, enter a name for the database connection.
4. Select a data source type of Essbase.
5. In Server, add the Essbase Server Name and Port Number.
6. Re-enter the User ID and Password.
7.To add application and database names, click the magnifying glass, and make your selections.
8. Finally , click OK .
The database connection profile is appended to the list in Database Connection Manager dialog box.