Arrow Storage Products EN106 Betriebsanweisung PDF herunterladen (Seite 37)

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.

Tip:

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

retrieval request.

To cancel data retrievals, press the Esc key during a retrieval action.

Note:

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

only.

Retrieving Data

1 2 ... 32 33 34 35 36 37 38 39 40 41 42 ... 199 200

Keine Kommentare

Arrow Storage Products EN106 Betriebsanweisung Seite 37