Spreadsheet Add-in User's Guide for Excel

Saving and Disconnecting

After performing basic retrieval, navigation, and formatting tasks, you can save worksheets and disconnect from Essbase. This section instructs you in the following procedures:

• Saving a Worksheet
• "Disconnecting from Essbase"
• "Logging Off"

Saving a Worksheet

At any point during the Essbase session, you can save the active worksheet with the Excel commands, File > Save or File > Save As. Thus, you can keep a personal library of database views. You can open the worksheet during a later session and retrieve the latest data values to update the view.

Note:

Saving a worksheet saves the settings from the Essbase Options dialog box unless the worksheet is protected. Essbase cannot save option settings for a protected worksheet.

Disconnecting from Essbase

When you finish retrieving and navigating through data, disconnect from the Essbase server to free up a port (or user count) on the server for other Essbase Spreadsheet Add-in users.

To disconnect from the server:

1. Select Essbase > Disconnect.

   Essbase displays the Essbase Disconnect dialog box, where you can disconnect any worksheet that is connected to a database.

   Figure 81. Essbase Disconnect Dialog Box
   
   
   

2. From the list, select a worksheet name, and then click Disconnect.
3. Repeat Step 2 until you have disconnected all active sheets.
4. Click Close to close the Essbase Disconnect dialog box.

Note:

You can also disconnect from the server by simply closing Excel. An abnormal termination of an Excel session, such as a power loss or system failure, does not disconnect your server connection.

Logging Off

Essbase provides two administrative facilities that control user connections:

• Forced Logout, where an administrator disconnects users at any point in time. This logoff usually occurs when maintenance operations are performed on databases.
• Auto Logout, where Essbase automatically disconnects users that are inactive for a time interval specified by an administrator.

For further information, contact the Essbase system administrator.