Databases Reference
In-Depth Information
Your
Zoom In
choices are explained as follows:
•
Next Level
: The zoom will go to the next level down from the selected
member from which you zoomed.
•
All Levels
: The zoom will go all the way down to the bottom
of the dimension and include all of the levels in-between.
•
Bottom Level
: This option will skip all intermediate levels and return
only the lowest level from the dimension that was zoomed on.
The rest of the choices are self-explanatory here and perform similarly.
The
Member Retention
section gives you options that tell Essbase what to do
with the member(s) that you selected for your zoom:
•
Include Selection
: This will zoom from the selected member to the
level determined by the previous set of options and also include the
selected member.
•
Within Selected Group
: When checked, the add-in will keep all members
if they are from the same logical group as the selected zoom member.
•
Remove Unselected Groups
: This will not return the members that are not
in a selected group. Be careful with this one because you can lose members
from your report and may need to start over.
The
Hybrid Analysis
option allows you to look at lower levels of data that is available
in the back-end relational database and not in your Essbase database. The outline
members are tagged as
Enable Hybrid Analysis
. In order to know which members are
hybrid analysis enabled you need to check the option
Enable Hybrid Analysis
. Unless
you are intimately familiar with your outline, this is probably best left unchecked.
In the
Sampling
section, you can type an integer from 1 to 100 which will tell Essbase
what percentage of the retrievable data to use when returning zoom data. Unless
your zooms are causing you memory or performance issues you can leave this at
100
.
Mode tab
The
Mode
tab allows the user to select the mode that Essbase will use to deliver the
data to the Microsoft Excel worksheet. There is also an option on this tab that allows
the user to control the read access mode that Essbase will use against the data while
a user is connected to a database and is actively retrieving data.