Databases Reference
In-Depth Information
The
Display Save Dialog
in the
Member Select
section, when checked, will open
a dialog box that allows you to save your member selections, so you do not need
to go through reselecting them if you need to recreate your report.
Next up is the
Mode
section. Here you can choose the option of
Navigate without
Data
. This will allow you to layout your report and retrieve into it to see how it
works without waiting for the actual data. This can be particularly helpful if you
have large amounts of data or many dynamically calculated members.
Display Messages
contains error reporting options. Essbase logs everything you do
in the system logs, so it is really upto you how much information you wish to receive
while you are working in Microsoft Excel. Your choices range from there being
virtually no error messaging (not a good idea), to having a small alert box appear with
a message for everything you do (also not a good idea). The best option is the
Errors
option which will only bother you if there are fatal errors in what you are trying to do.
Also, there no need to check the
Display Unknown Members
option because Essbase
will tell you if you are trying to retrieve data into a member that does not exist.
In the
Log File
section you have two options:
•
Route Messages to Log File
: This option will often create large log files
on your client and is not very helpful or necessary
•
Purge Log File Every Session
: A good idea so you do not create huge,
system slowing log files on your client.
Lastly, the
Add-Ins
button allows you to load custom Essbase add-ins. These can
be API calls, custom coded functions, or any other repeated functionality that has
an add-in format.
Selecting Essbase members for your query
This menu pick is probably the next most used tool after the options screens.
The
Essbase Member Selection
screen allows you to quickly and easily set up
and populate Microsoft Excel worksheets with your Essbase data.
The basics for this tool are simple. First, make sure you are logged into the
appropriate Essbase Application|Database. Second, always remember to select
the cell on the Microsoft Excel worksheet where you want the member data to
begin populating with your member selections. Third, always remember that you
can only select members from one dimension at a time with the Essbase member
selection tool.
Select the cell on the worksheet where you want to begin populating report criteria
data. To load the
Essbase Member Selection
screen click
Essbase
|
Member
Selection…
from the Microsoft Excel main menu toolbar.
