OLAP Spreadsheet Add-in User's Guide for 1-2-3

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 Lotus 1-2-3 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 82. 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.