Lesson: Updating Data on Essbase Server

After you retrieve data into a spreadsheet and modify values, you need to upload your changes to Essbase Server. 

This lesson uses the P&l.xls file (installed with Spreadsheet Add-in) to illustrate how to update data on the server.

  To update data from P&l.xls to Essbase Server:

  1. Select File, and then Open.

  2. From  EPM_ORACLE_HOME/products/Essbase/EssbaseClient/client/sample, open P&l.xls.

  3. Select Essbase, and then Retrieve & Lock.

    Essbase retrieves data and locks the database area to prevent other users from altering it and interfering with your changes.

    P&L worksheet after Retrieve & Lock.

  4. Change the value for Sales in Jan (cell B12) to 4000 and press Enter.

    Essbase changes the affected data values.

  5. Select Essbase, and then Send.

    Essbase updates the server and unlocks the data blocks.

    P&L worksheet after sending new values to the server.

  6. Close P&l.xls without saving it.

User Reference

Updating Data on Essbase Server.