Lesson: Disconnecting from Essbase

When you finish using drill-through, disconnect from Essbase to make a port available on the server for other Spreadsheet Add-in users.

  To disconnect from the server:

  1. Select Essbase, and then Disconnect.

    The Essbase Disconnect dialog box is displayed, from which you can disconnect spreadsheets that are connected to a database.

    Essbase may return an error message when you attempt to disconnect after using drill-through. If an error message is returned, select Essbase, then Retrieve, and then disconnect.

  2. Select a sheet name from the list, and then click Disconnect.

  3. Repeat step 2 until you disconnect from all active sheets.

  4. Click Close.

    Note:

    You can also disconnect from the server by closing the spreadsheet application. An abnormal shutdown of a Spreadsheet Add-in session, such as a power loss or system failure, does not disconnect you from the server.