Lesson: Retrieving a Range of Data

You can select a range of cells and tell Essbase to restrict the data retrieval to the selected range in the worksheet.

As part of the default Essbase installation, the Profit.xls sample file illustrates how to retrieve a range of data.

  To retrieve a rage of data using Profit.xls:

  1. Select File, and then Open.

  2. From EPM_ORACLE_HOME/products/Essbase/EssbaseClient/client/sample, open Profit.xls.

    Note:

    Depending on how software is installed on your computer, the file may not be available or may be in another directory. Contact the Essbase system administrator for the location of the file.

    When you open Profit.xls, the range of cells from B2 through F9 is selected for you.

    Selected range of cells for retrieval.

  3. Select Essbase, and then Retrieve.

    Essbase updates only the data in the selected range of cells.

    Result of retrieving the first range of data.

  4. Select cells B12 through G16.

    Selecting cells B12 through G16 for retrieval.

  5. Select Essbase, and then Retrieve.

    Essbase updates the data in the selected range.

    Result of retrieving the second range of data.

  6. Close the file without saving it.