Databases Reference
In-Depth Information
•
Note
: This is a note that resides with the Essbase database and is also called
a
Database Note
. This note can contain information left by the administrator
about the current state of the database and its data. This can be a very useful
feature for the end-users or current production support staff.
Disconnecting from Essbase
There are three main reasons to get very familiar with this function:
1. Once you are working with Essbase, your connections will remain open, even
if you close the Microsoft Excel workbook. The connections to the Essbase
server are only terminated when you close Microsoft Excel or explicitly
disconnecting each sheet manually or with code. To avoid potential connection
issues, it is always advisable to disconnect all Microsoft Excel worksheets when
you are finished with them.
2.
If you need to retrieve data into the same sheet from a different database,
it is good to disconnect it first before you connect it to another database.
3.
The
Essbase Disconnect
screen is the best way to monitor what sheets
are connected to what Application|Databases and even servers. It is not
uncommon to have multiple sheets in the same workbook connected to
databases from different applications across different servers.
