Updating Data on Essbase Server

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

Before you update data from a spreadsheet to Essbase Server, you must lock the database area that contains the values that are changing, because Essbase allows user concurrent database access and updates. Locking prohibits other users from changing or updating the data. Other users can retrieve locked data but cannot lock or change the data. Only you can access the locked area.

Note:

You cannot update attribute-related data on the server because attribute data is calculated dynamically and, hence, is not saved.

Essbase provides a spreadsheet update logging facility that tracks and logs all data updates sent from Spreadsheet Add-in to Essbase Server. The Essbase System Administrator enables this facility for extra protection against data loss.

To update data on Essbase Server:

Select one method to lock the area of the database containing the data you want to change:
- To retrieve data into the worksheet while simultaneously locking the corresponding data area on the server, select Essbase, and then Retrieve & Lock. When you perform a subsequent retrieval, Essbase automatically unlocks the previous data values.
- To lock information that you previously retrieved, select Essbase, and then Lock. When you perform a subsequent retrieval, Essbase automatically unlocks the previous data values.
- To automatically lock the corresponding database area with each retrieval, select Essbase, and then Options. In Mode, select Update Mode.
  Note:
  Update mode applies only to block storage databases.
To upload data values from the spreadsheet to Essbase Server, select Essbase, and then Send.
If data blocks are locked, Send automatically unlocks data after updating Essbase Server, unless you are in Update mode (block storage databases only). You must clear Update mode to stop locking blocks automatically.
To unlock all blocks that you locked, select Essbase, and then Unlock.
The server automatically unlocks data blocks that are locked for the maximum time allowed. The maximum amount of time that locks are in force is defined by the Essbase System Administrator to ensure that blocks are not locked for extended periods of time. The Essbase System Administrator can unlock data blocks at any time.