Example 5: Administrator Must Perform Maintenance

The Administrator, Sue Smith, needs to perform maintenance on the Sample application. She must make changes to the database outline and reload data. While she changes the application, Sue must prevent other users from connecting to the application.

Solution When Using Essbase in Native Security Mode:

Sue should perform the following tasks:

  1. Disable the Allow Commands setting to prevent other users from connecting to the application and to prevent connected users from performing further operations.

    See “Clearing Applications of User Activity” in the Oracle Essbase Administration Services Online Help.

  2. Check to see if any users have active locks.

    If any users have active locks, Sue’s calculation or data load command might halt, waiting for access to the locked records. Sue can allow the users to complete their updates or clear their locks.

    See “Viewing Data Locks” in the Oracle Essbase Administration Services Online Help.

  3. After confirming that no users have active locks, proceed to perform maintenance on the application.