To use Spreadsheet Add-in with Essbase, you must first log on to an Essbase Server.
Essbase does not support multiple instances of Excel.
To log on to the server:
In Excel, select Essbase, and then Connect, to open Essbase System Login.
In Server, select the server to access or enter a server name.
Enter your user name.
Enter your password.
When the server connection is complete, a list of available application and database pairs displays in the Application/Database list.
One instance of Essbase Server enables simultaneous access to multiple applications. An application can contain multiple databases. Only databases that you are permitted to access are listed.
In Application/Database, select an application and database pair, and then click OK.
If the application is not running, Essbase automatically starts it. Essbase may pause briefly while loading the application; 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.