Essbase - Calculations

Essbase Overview


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 gives users the flexibility to build, customize, and extend the calculator through custom-defined macros and functions, as well as the ability to span calculations across databases. On multiprocessor systems, a DBA can configure a single calculation request to use multiple threads to accomplish the calculation, providing enhanced calculation speed.

Aggregate storage databases provide an alternative to block storage databases and enable dramatic improvements in database aggregation time for certain types of applications.

By default, Essbase calculates only data that changed since the prior calculation (known as Intelligent calculations).

Essbase offers two methods for calculating a database:

The method that you choose depends on the type of calculation that you want to perform.

Methods of calculation

Outline-based Calculations

Outline Calculation represent the simplest method of calculation. In block storage outline calculations, Essbase calculates the cube according to :

Script-based Calculations

For more complex calculations than can be defined in the outline, Essbase provides calculation scripts, which are stored separately from the outline and are calculated as necessary.

Type of calculations

Discover More
Card Puncher Data Processing
EPM - Calculation Manager (calcmgr)

Application installed in Weblogic. Calculation Manager means ? URL:
Essbase Overview
Essbase - (Accounts|Measures) Dimensions

Accounts dimensions are dimension that contains items that you want tomeasure, and makes Essbase built-in accounting functionality available. Accounting classifications. Ex: income expense profit...
Essbase Overview
Essbase - (Consolidations|Aggregations)

Member consolidation Operators, determine how children roll up into their parents. Consolidation define how the data are aggregate. Consolidations are also known as aggregation rules. Consolidation...
Essbase Overview
Essbase - ASO/BSO Storage

Essbase support two storage type : block storage (BSO) and aggregate storage (ASO) as a persistence mechanism for multidimensional databases. How the data are internally stored is determined by...
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 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 - Attribute calculations

A calculations for a member of an attribute dimensions.
Essbase Overview
Essbase - BSO Access Path

Essbase BSO uses two types of internal structures to store and access data: data block and index Accessing a cell in the data block does not involve sequential or index searches. The search...
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 - Cell

A cell is a part of a data block and represent a combination of the dense dimension members. Essbase orders the cells in a data block according to the order of the members in the dense dimensions of the...

Share this page:
Follow us:
Task Runner