Spreadsheet Add-in User's Guide for Excel
After performing basic retrieval, navigation, and formatting tasks, you can
save worksheets and disconnect from Essbase. This section instructs you
in the following procedures:
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.
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:
- 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
![](sdlogout.gif)
- From the list, select a worksheet name, and then click
Disconnect.
- Repeat Step 2 until you have disconnected all active sheets.
- 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.
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.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]