59
Button
Purpose
Description
Navigate with or without data
Toggles the Navigate Without Data feature, which tells Essbase to retrieve
or not to retrieve data when you perform navigational operations, such
as pivot, drill down, drill up, keep only, and remove only.
This button serves the same function as the Navigate Without Data check
box in the Essbase Options dialog box (Global tab).
Retrieve
Retrieves data into the active worksheet. A retrieve request places data
at the beginning of the active worksheet. When you click the Retrieve
button, if you are not already connected to an instance of Essbase Server,
the Essbase System Login dialog box is displayed.
Tip: If you have mouse actions enabled, you can retrieve data by double-
clicking the primary mouse button in any empty cell in the worksheet. To
enable double-click support, select Essbase > Options, select the Global
tab, and select the Enable Double-Clicking option. For more information,
see “Enabling Mouse Actions” on page 26.
Keep only
Retains only the selected member (the active cell) or member range in
the worksheet. Click the Keep Only button to remove all unselected
members from the worksheet.
Remove only
Removes the selected member (the active cell) or member range from
the worksheet. Click the Remove Only button to retain all unselected
members in the worksheet.
Zoom in
Retrieves and expands data from Essbase according to the options
specified in the Essbase Options dialog box.
When sampling is enabled (Essbase > Sample Data (Zoom In)), an
approximate percentage members of the Essbase database that you
specify is queried when you retrieve and expand data.
Tip: If you have mouse actions enabled, you can drill down on data by
double-clicking the primary mouse button in the cell that contains the
member you want to expand. To enable double-click support, select
Essbase > Options, select the Global tab, and select the Enable Double-
Clicking option. For more information, see “Enabling Mouse Actions” on
page 26.
Zoom out
Collapses the view according to the options specified in the Essbase
Options dialog box in the cell that contains the member that you want to
collapse. To enable double-click support for drilling up, select Essbase >
Options, select the Global tab, and select the Enable Double-Clicking
option.
Open Essbase Query Designer
Opens the Essbase Query Designer, which makes it easy to define a page
orientation for dimensions and selected database members. You can also
save queries for later use. Query Designer is designed to create report
queries, view attributes, and perform calculations based on attributes.
FlashBack
Restores the previous worksheet view.
Set options
Enables you to set display, zoom, mode, style, and global options for the
active worksheet to customize the behavior of Spreadsheet Add-in
software. Click the Options button to display the Essbase Options dialog
box.
Getting Acquainted with Spreadsheet Add-in
25