Essbase - Database (cube)

Essbase Overview


An Essbase database is a data repository that contains a multidimensional data storage array.

Essbase Database is also commonly referred to as cube (as in Essbase Studio console)

Files that are related to databases are called artifacts (or objects).


You can create :

Except for databases requiring use of the Currency Conversion option, creating one database per Essbase - Application (Directory Structure) is recommended.

Managing a Database


Essbase supports concurrent multiple users reading and updating the database; therefore, users can use the database while you are dynamically:

In a multi-user environment, Essbase protects data by using the security system described in Essbase - User management and security.

  • Security Issues

The security system prevents unauthorized users from changing the database. Only users with write access to a database can load data values or add dimensions and members to the database. 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 to a database. 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. See Ensuring Data Integrity for information on Essbase transaction settings, such as identifying whether other users get read-only access to the locked block or noting how long Essbase waits for a locked block to be released.
    • Updates the block. See Data Locks for information on whether Essbase unlocks a block when its update is complete or waits for the entire data load to complete before unlocking the block.
  • Multi-User Dimension Build Issues

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


A database note can provide useful information when you need to broadcast messages to users about :

  • the status of a database,
  • deadlines for updates,
  • and so on.

Users can view database notes in Essbase - Spreadsheet Add-in.

To annotate a database, see “Annotating Databases” in the Oracle Essbase Administration Services Online Help.

Discover More
Administration Services Architecture
Essbase - Administration Service (EAS)

Administration Services—the database and system administrators’ interface to Essbase—provides a single-point-of-access console to multiple . Administration Services is a tool which permit you to...
Essbase Overview
Essbase - Aggregate Storage

Essbase provides an aggregate storage kernel as a persistence mechanism for multidimensional databases. Aggregate storage database are optimized for sparse data set that primarily require simple aggregation....
Essbase Folders Structure
Essbase - Application (Directory Structure)

An Essbase application is a management structure that contains : one or more database (cube) and related files called artifacts Essbase applications and databases reside on an essbase servers....
Essbase Overview
Essbase - Artifacts/Objects

Files that are related to are called : artifacts or objects. Database artifacts perform actions against one or more Essbase databases, such as : defining or reporting against data. In...
Essbase Overview
Essbase - Block storage

Block Storage databases are optimized for data set that are partially denses. Data is stored in dense data blocks which are indexed along sparse dimension for retrieval. This storage paradigm enables...
Essbase Calculations Script Process
Essbase - Calculation Script

Calculation scripts are text files that define how to calculate data in the database. In a block storage database, they represent the second method of calculations after the basic outline calculations...
Essbase Overview
Essbase - Calculations

Essbase includes powerful calculation features for demanding analytic requirements. A rich library of functions makes it easy to define advanced and sophisticated business logic and relationships. Essbase...
Essbase Overview
Essbase - Creating / Copying a database

When you create a database, Essbase creates a subdirectory for the database within the application directory. The new subdirectory has the same name as the database. For example, ARBORPATH/app/app1/dbname1....
Essbase Overview
Essbase - Data Load

Loading data is the process of adding data values to an database from a data source. If the data source is not perfectly formatted, you need a data load rules files to load the data values. You can load...
Essbase Overview
Essbase - Data Mining

Data Mining reveals hidden relationships and patterns in your data, enabling you to make better business decisions. Using Data Mining, you can plug in various data mining algorithms, build models, and...

Share this page:
Follow us:
Task Runner