When you retrieve data into an empty worksheet, Essbase returns data from the top levels of
each database dimension. The top level is used as a starting point to navigate, or drill down, into
levels of detailed data. In the Sample Basic database, the following five dimensions are retrieved:
Measures, Product, Market, Scenario, and Year.
You can retrieve data by double-clicking in a data cell, selecting Essbase > Retrieve, or by clicking
the Retrieve button on the Essbase toolbar.
Canceling a Data Retrieval Request
Occasionally, you may want to cancel a retrieval request. For instance, you may want to stop a
request if a retrieval is taking longer than expected or if you mistakenly double-click.
Because Essbase returns data so quickly to the worksheet, you may not be able to cancel a retrieval
before the retrieval is complete. The cancel feature is most useful when you need to stop a large
To cancel data retrievals, press the Esc key during a retrieval action.
You can cancel a retrieval only while Essbase is processing in Spreadsheet Add-in. You cannot
cancel a retrieval when Essbase is processing from Essbase Server.
Restoring the Previous Database View
The FlashBack command restores the previous database view. A database view is what you see
in the worksheet after a retrieval or navigation operation. FlashBack is similar to the Edit >
Undo command, which reverses the last action, with the following difference. If you modify
member information between retrieves and then perform a FlashBack, Essbase still flashes back
to the spreadsheet data as it was prior to the last retrieve, in spite of any changes you may have
made to members between retrieves. The FlashBack command uses the memory of your
computer to store the current view before processing an Essbase retrieval request. You can use
FlashBack to undo only the most recent operation. FlashBack cannot undo multiple operations.
Throughout this tutorial, you should follow all steps in the order that they are presented. If you
make a mistake or find yourself out of step with the tutorial, you can use the FlashBack command
from the Essbase menu or toolbar to undo the last command and return to the previous database
view. If you want to start the tutorial over from the beginning, select the entire worksheet and
select Edit > Clear > All. Then press Enter or click OK to empty the worksheet and start again.
You can disable FlashBack during normal operations to conserve memory on your local
machine. Do not disable FlashBack for this tutorial.
This task is optional. Optional tasks do not need to be performed as part of the tutorial. They are provided for information