Essbase supports simultaneous access to multiple databases. The databases can be in different applications and can be stored on different servers. You can also open multiple worksheets, each of which can be connected to another database.
While an individual worksheet can access only one database, you can switch the connection by using the Connect command.
If you rename a worksheet, verify the database connection by selecting Essbase, and then Disconnect, and viewing the connection information in the Essbase Disconnect dialog box. If the connection information is not what you expect for the renamed worksheet, disconnect the worksheet from the application and reconnect using the Connect command.
Depending on the status of production applications at your site, you may not have access to additional applications or databases. Contact the Essbase System Administrator to access other applications.
To connect to multiple databases:
Essbase System Login is displayed.
If the application is not running, Essbase automatically starts it. Essbase pause briefly as the application loads; the time required to start an application depends on the size and number of databases contained within the application and the size of their indexes.
You can access one database per worksheet.