Essbase - Consolidation Path

Essbase Overview

About

The definition of the consolidation operator define the consolidation path.

Example

The TBC application has several consolidation paths:

  • Individual products roll up to product families, and product families consolidate into Product. The TBC outline also requires multiple consolidation paths; some products must consolidate in multiple categories.
  • States roll up to regions, and regions consolidate into Market.
  • Months roll up into quarters, and quarters consolidate into Year.

Consolidation of Shared Members

The operators but also shared member affect consolidation paths. The shared member concept enables two members with the same name to share the same data. The shared member stores a pointer to data contained in the other member, so Essbase stores the data only once. Shared members must be in the same dimension. Data can be shared by multiple members.





Discover More
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...
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...



Share this page:
Follow us:
Task Runner