OLAP 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 Hyperion Essbase. This section instructs you in the following procedures:

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

Saving a Worksheet

At any point during the Hyperion 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. Hyperion Essbase cannot save option settings for a protected worksheet.

Disconnecting from Hyperion Essbase

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

To disconnect from the server:

1. Select Essbase > Disconnect.

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

   Figure 83. Hyperion 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.

Logging Off

Hyperion 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 Hyperion Essbase automatically disconnects users that are inactive for a time interval specified by an administrator.

For further information, contact the Hyperion Essbase system administrator.