Consolidation Process

Data is typically entered into base-level members of dimensions and not into

parent members. Values for parent-level members are aggregated from the

children of the parent-level members. In some cases, data for base-level members

is calculated. For example, the Salaries account member might be a base-level

member whose value is calculated based on head count and salary rate. In the

illustration in the slide, the data values from the base-level members are rolled up to the parent-level members—Total Revenues and Total Costs. Data values from Total Revenues and Total Costs are then rolled up to their parent, Gross Margin.

Financial Consolidation

Consolidation is the period–end process of combining the financial results of

separate subsidiaries with the parent company to form a single, combined

statement of financial results.

Consolidation is the process of gathering data from descendants and aggregating

the data to parent entities. Consolidation applying only to Entity dimension.

After loading or entering data into base level entities we run a consolidation for a

selected scenario or period to aggregate data throughout the organization.

Steps to perform consolidation

Before Consolidate

After Consolidate

When you consolidate an entity, the processes are required for the descendants of the entity run automatically.

• Calculation rules are run for all descendants of the entity for the period

being consolidate and for all prior periods

• If the data for the children & parent entities are in different currencies the data is translated based on the exchange rate.

• Intercompany transactions between entities are eliminated at their first common parent.

• Data is consolidated from base level entities to parent entities.