Consolidation options

This section includes all the consolidation options. Not all options listed are available for all types of consolidations.

The Compute Allocations option computes allocation formulas for translated currencies. For information on creating allocation formulas, see the Infor CPM Administration Guide. This option is not available for local consolidations.

The Read Local Consolidated Data option reads and translates data that is loaded or submitted to non-leaf members of hierarchical dimensions (except the Period dimension). This option is ignored during level depth consolidations.

The Read Consolidated Member P0 Balances option determines whether P0 data for consolidation members is read from the database or recalculated by the consolidation process. When this option is selected, P0 data is read from the database. Always Read Consolidated Member P0 Balances from the database if ownership relationships change during the year. Deselect this option to have the consolidation process calculate the P0 balance by taking the legal unit's P0 ending balance data and applying the P0 ownership percentages. Recalculating P0 balances for consolidation members is recommended if ownership relationships do not change throughout the year.

The Skip Local Consolidations option omits writing local currency results back to the database when translating currencies. This option is not available for local consolidations.

The Use Net Adjusted Off-sheet Data option is for Financial Consolidation only. It evaluates adjustment data and net data for formulas whose sources are not part of the consolidation scope and have been adjusted. Select this option only when the consolidation scope does not include adjustments to the selected accounts. This option is not available on the Local Consolidation form.

The Point Consolidation option writes data back to the database for the selected member and its leaf members but skips the intermediate members. When Suppress Leaf Writeback is also selected, a point consolidation only writes data back to the selected member. It is disabled if Level Depth Consolidations is selected.

The Suppress Leaf Writeback option suppresses writeback to leaf members during a consolidation. This option is not available on the Consolidation Status Monitor page. It is disabled if the Level Depth Consolidations option is selected.

The Ownership Managerial Consolidation option displays when the Ownership process is turned on. If this check box is selected, the consolidation engine does not roll up data at 100% following the structure created in Architect at consolidation nodes where the unit exists without a holding parent unit.

The Level Depth Consolidations option reads previously consolidated parent members (virtual leaf member) at the starting level of the consolidation and also consolidates and reads all true leaf member at this level. It then consolidates all remaining members up to, and including, the target member.

• For Dimension, select a hierarchical dimension for the starting level of the consolidation.
• For Level, select how many levels down from the selected member you want to start the consolidation. Level 1 includes the children of the selected member; level 2, the grandchildren; level 3, the great-grandchildren, and so on. You can select up to ten levels (0-9). The 0 level is a special case that allows you to start the consolidation at the leaf level (if leaf processing is not suppressed). Use level 0 if your data slice includes ownership data.
• The Suppress Leaf Processing option reads existing data from in-scope leaf members without reconsolidating. Leave the check box clear to consolidate in-scope leaf members. If Suppress Leaf Processing is selected and the level depth is 0 (resulting in a currency consolidation), ownership data is used for rollups, and Ownership journals are posted. If this option is clear, ownership data is used for rollups, but Ownership journals are not posted.

  A level depth consolidation ignores the Read Local Consolidated Data option and cannot be used with the Point Consolidation option.

The Calculation passes option determines the number of consolidation passes to perform. The default setting is 1.

The Seconds between Progress Updates option determines how frequently the Consolidate Status dialog box should refresh during the consolidation. The default is every 30 seconds.

The Process Unsubmitted Statements option determines whether to process all in-scope leaf member combinations or only those with data during a local consolidation. This option is useful if a schedule includes only formulas that need to be calculated but otherwise the schedule is empty. It is also useful if there are cross-dimensional formulas or allocation formulas on a schedule. These formulas can pull data from other places so that even if no data has been submitted for the selected schedule, the formulas on the schedule can use data from other sources.