Lesson: Retrieving Data Using Functions

You can use the Essbase cell retrieve function, EssCell, to retrieve data when you perform an Essbase retrieval or when you recalculate a worksheet through Excel. As part of the default Essbase installation, the Summary.xls sample file is provided with EssCell functions set in cells B16 and B17.

  To retrieve data in Summary.xls using EssCell:

  1. Select File, and then Open.

  2. From  EPM_ORACLE_HOME/products/Essbase/EssbaseClient/client/sample , open Summary.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 this file.

    The values in cells B16 and B17 are currently #N/A.

    Worksheet containing EssCell functions.

  3. Select cell B16 to view the EssCell function in the formula bar at the top of the worksheet:

    =EssCell("Sales", A1, A2, B4, F5)

  4. Select Essbase, and then Retrieve.

    Essbase calculates the EssCell functions in cells B16 and B17.

    Retrieval on a worksheet containing EssCell functions.

    Now update the EssCell functions to retrieve data for another state.

  5. Change the contents of cell A2 from Texas to Florida.

    The values in cells B16 and B17 are updated as soon as you update the cell. The update occurs because you configured Excel to calculate changes automatically. The remaining data cells do not change.

    Updating EssCell functions.

  6. Select Essbase, and then Retrieve.

  7. Close the file without saving it.

User Reference

Retrieving Data Using Functions