If you have Administrator permissions, you can view a list of users who hold locks on data for an Essbase Server. For example, you can find out which Spreadsheet Add-in users currently hold locks on data. Locks on data expire after a specified timeout period, as set in the Application Properties window. You may need to release locks before the allotted time expires. See Unlocking Data.
User locks on data are different from locks on database objects, such as calculation scripts and rules files. For more information on object locks, see Locking and Unlocking Objects.
Note: | Data locks do not apply to aggregate storage databases. |
To view a list of current locks on data:
In Enterprise View or a custom view, select the Essbase Server for which you want to view data locks.
Right-click and select Edit, then Locks.
The Locks window displays a list of users who currently hold at least one locked data block for the server.
To refresh the list of locks, click Refresh.
To remove a lock, see Unlocking Data.
listlocks (ESSCMD) in the Oracle Essbase Technical Reference
removelocks (ESSCMD) in the Oracle Essbase Technical Reference