1. Database Administrator's Guide for Oracle Essbase
  2. Overview of Data Load and Dimension Build
  3. Security and Multiple-User Considerations

Security and Multiple-User Considerations

Because Essbase supports concurrent users reading and updating the cube, users may be active when you are attempting to perform dimension builds, data loads, and calculations.

Security Issues

The security system prevents unauthorized users from changing the cube. Only users with write access can load data values or add dimensions and members. Write access can be provided globally or by using filters.

Multi-User Data Load Issues

You can load data values while multiple users are connected. Essbase uses a block locking scheme for handling multi-user issues. When you load data values, Essbase does the following:

  • Locks the block it is loading into so that no one can write to the block.

  • Updates the block.

Multi-User Dimension Build Issues

You cannot build dimensions while other users are reading or writing to the cube. After you build dimensions, Essbase restructures the outline and locks the cube for the duration of the restructure operation.