Example of an Entity Aggregation

Aggregated Dimension

Example of Cube View Using C#Aggregated Dimension

• Rows

  • Entity: E#[North America].TreeDescendantsInclusive

• Columns

  • Consolidation: C#Aggregated, C#Aggregated:V#CalcStatus, C#Local, C#Local:V#CalcStatus

  • Time: T#2018M1, T#2018M12

Aggregate Jan 2018, by right-clicking on the number and pick Consolidate to Aggregate numbers. Context aware algorithms are used recognize the Aggregated member.

Notes:

• No Parent Journal Adjustments

• No Eliminations

• Business Rules (execute at the base level only)

• Select different Consolidation member (C#Aggregated) to run Consolidation on and pick the numbers that were loaded.