Essbase - Consolidation Path

About

The definition of the consolidation operator define the consolidation path.

Articles Related

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.