Which dimension type would you use to consolidate data from subsidiaries into a single parent figure?

Which dimension type would you use to consolidate data from subsidiaries into a single parent figure?

• A. Time
• B. Consolidation
• C. Intercompany
• D. Flow

Answer: (B)

Consolidation across multiple entities requires a dimension that defines the ownership and grouping of subsidiaries under a parent. The Consolidation dimension is designed for this purpose: you place each subsidiary and the parent as members, establish the consolidation relationships, and the system rolls up the subsidiary values into the parent, applying any required adjustments or eliminations. This gives you a single parent figure that represents the consolidated result. Time is for time periods, not entity structure. Intercompany helps model and eliminate intercompany transactions, but the actual consolidation hierarchy and roll-up are driven by the Consolidation dimension. Flow relates to data movement or process flows, not the entity-level consolidation itself.

Consolidation across multiple entities requires a dimension that defines the ownership and grouping of subsidiaries under a parent. The Consolidation dimension is designed for this purpose: you place each subsidiary and the parent as members, establish the consolidation relationships, and the system rolls up the subsidiary values into the parent, applying any required adjustments or eliminations. This gives you a single parent figure that represents the consolidated result.

Time is for time periods, not entity structure. Intercompany helps model and eliminate intercompany transactions, but the actual consolidation hierarchy and roll-up are driven by the Consolidation dimension. Flow relates to data movement or process flows, not the entity-level consolidation itself.