Combine multiple Strategic Finance (*.alc) models to form a single entity to better analyze your enterprise. Consolidator helps determine how changing business unit conditions affect parent company earnings and values. After reviewing the consolidated entity, you can make informed decisions about individual business units.

You can consolidate business unit information such as method, scenario, time period, subaccount detail, organizational levels, and export the consolidated parent, in addition to consolidation metadata, to your relational database for advanced querying, analysis, and reporting. See About Exporting Consolidation Metadata for Extended Analytics.

Business unit entities do not require matching structures—they can have different scenarios, time periods, forecast methods, subaccount structures, residual value methods, currency denominations, and treatments for debt/interest and taxes. You may include entities with incomplete financial structures, such as corporate files containing only general expenses and fixed assets. There are some restrictions on consolidating data.

Identify the information for analysis before deciding what to consolidate to determine business unit details and the manner of consolidation. For example, if you are considering divesting a portion of a business unit, you would want to consolidate 100% of the earnings and the balance sheet amounts up until the transaction date, consolidate the unsold portion of the unit after the transaction date—you would enter the child entity twice, with the appropriated time periods selected for consolidation.

For optimizing consolidations:

  • Parent entities should never forecast variables accepting input based on funding options results.

  • To optimize consolidation speed at the cost of storage, activate Store outputs for all accounts in Scenario Manager for each entity to avoid recalculating unchanged values.