Retrieving Data Ranges

You can select to retrieve a range of cells .

Selection retrievals are useful when:

A worksheet contains multiple reports.
A worksheet contains extraneous information that is not supported in a formatted report retrieval.
You must retrieve only a small subset of values from the database, which dramatically decreases retrieval time for large data sets.
You must retrieve data to an area of the worksheet other than the first column.

To retrieve a selected range of data:

Drag the mouse across the range of cells in the worksheet.
Select Essbase, and then Retrieve.

When you retrieve data, Essbase restricts the retrieval to the selected range in the worksheet.

Note:

Essbase uses only the selected range as input, so ensure that the range provides a query. See the Oracle Essbase Spreadsheet Add-in User's Guide for an example of retrieving a range of data.