Essbase - (Consolidations|Aggregations)

Essbase Overview

About Consolidations

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 is the most frequently used calculations in Essbase.

By default, new members are given the addition (+) operator, meaning that members are added. For example, Jan, Feb, and Mar figures are added and the result stored in their parent, Qtr1.

Essbase does not use consolidation properties with members of attribute dimensions. See Calculating Attribute Data.

The consolidation operator defines the consolidation path.

Article Related

Documentation / Reference





Discover More
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...
Tbc Product Dimension
Essbase - Consolidation Operator

The consolidations operator define the consolidation path and can be used in formulas. It defines how Essbase rolls up data for each member in a branch to the parent. Operator Representation Description...
Essbase Overview
Essbase - Consolidation Storage Properties

Data storage properties define where and when consolidations are stored. For example, by default, members are tagged as store data. Essbase sums the values of store data members and stores the result...
Essbase Data Source Record Fields
Essbase - Data Source

A data source is external data that is loaded into an database with the help of one this two process : Data sources contain the information that you want to load into the Essbase database. A data...
Essbase Overview
Essbase - Data load in a parent member overwritten by consolidation

If you work with a block storage database (not aggregate storage) and then you load data into a parent member, when you calculate the database, the consolidation of the children’s data values can overwrite...
Essbase Dimension Build Rules Files
Essbase - Dimension build rules files

When you create dimension with thousands of member or with many alternate hierarchy, you want to automate the process to add the member. You use Dimension build rules files to map dimension and member...
Essbase Generation
Essbase - Generation

generation relationship of the members in a database outline. Generation refers to a consolidation level within a dimension.
Essbase Outline
Essbase - Hierarchies

Essbase uses the concept of member to represent data hierarchies. Dimension contain Member, which you can nest inside of other members in a Hierarchies. Hierarchies also define the relationship that...
Essbase Overview
Essbase - Members

Members are the individual components of a dimension. For example: the members of a Region dimension can be East, West, South, and Total US. Product A, Product B, and Product C might be members...
Essbase Outline
Essbase - Outline (Database Outline)

An outline (also known as database outline) define the database design in a tree structure which define : dimension member consolidations formulas and calculations scripts aliases, properties,...



Share this page:
Follow us:
Task Runner