Managing User Locks in Essbase Native Security Mode

Spreadsheet Add-in users can interactively send data from a spreadsheet to the server. To maintain data integrity while providing multiple-user concurrent access, Essbase enables users to lock data for the purpose of updating it. Users who want to update data must first lock the records to prevent other users from trying to change the same data.

Occasionally, you may need to force an unlock operation. For example, if you attempt to calculate a database that has active locks, the calculation must wait when it encounters a lock. By clearing the locks, you allow the calculation to resume.

Only Administrators can view users holding locks and remove their locks.

  To view or remove locks, use a tool:

Tool

Topic

Location

Administration Services

Viewing Data Locks and Unlocking Data

Oracle Essbase Administration Services Online Help

MaxL

drop lock

Oracle Essbase Technical Reference