1. Using Oracle Essbase
  2. Manage Application and Cube Artifacts and Settings
  3. Remove Data Locks

Remove Data Locks

Data locks apply to block storage cubes only.

Occasionally, you may need to release a lock that you created in the cube, generally from a Smart View Submit Data action. For example, if you’re calculating a cube that has active locks on data, and the calculation encounters a lock, then the calculation must wait. If you release the lock, the calculation can resume.

You can always unlock data that you locked. To remove another user’s data locks, you must have the Application Manager or Database Manager role.

Use these steps to remove data locks from Essbase cubes in the Essbase web interface.
  1. Navigate to Locks.
    In the Redwood Interface:
    1. On the Applications page, open the application and then open the database (cube).
    2. Click General in the left hand panel.
    In the Classic Web Interface:
    1. On the Applications page, expand the application.
    2. From the Actions menu, to the right of the cube name, click Inspect.
  2. Click the Locks tab.
  3. From the Display menu, select Blocks.
  4. Select the lock and click Unlock.