Consolidation Manager Report


Return to Financial Consolidation Model Overview.

Consolidations are run in the Consolidation Manager report. Here you can execute a consolidation for a specific data slice and then have a look at the resulting journal entries.

Report Heading

The report heading updates dynamically as various reporting options are selected. Below it shows the slice for Actual, 2018-12_YTD and All Scopes.

You can select your base elements in the combo boxes below the report heading:

The Version dimension separates actual figures from planning figures, see full article. The Month_YTD dimension accumulates float values from the beginning of the calendar year to the current date, while respectively holding the final figure for stock values. The Scope dimension contains all target elements for financial consolidation in a flat list, see full article. Check the Consolidation Ledger checkbox to run the consolidation on the regular cubes Profit and Loss, Balance Sheet and Cash Flow. Check the Segment Consolidation Ledger to run the consolidation on the more detailed segment cubes Profit and Loss (Segment), Balance Sheet (Segment) and Cash Flow (Segment)

Execute Consolidation Procedure

Click the Consolidate button to run the consolidation for your defined data slice.  An popup dialog will appear indication that the consolidation is running.

You must then click the Get Job Status button to see your results.

The full consolidation procedure starts by reversing the result from any previous consolidation on the same slice.

Click the Reverse Consolidation button if you wish to run this step of the consolidation procedure, but not the full consolidation. This step reverses the posted journal entries. Reversed journal entries will show up as reversed in the posting journal but these entries will not modify figures in any of the fact cubes.

Please note: it is not necessary to select Reverse Consolidation before selecting Consolidate: the consolidate function reverses posted journal entries and posts new ones, while the Reverse Consolidation only does the former.

Journal Entries in Posting Journal

Your results appear in a table showing the number of consolidated journal entries in the posting journal, organized both by scope and groups of consolidation measures. You can click the blue arrows to open the journal entries in a separate tab. From here you can click each separate journal entry to view it in more detail.

The columns show the Consolidation Rules:

Field Definition
Capital Consolidation The group of any consolidation measures on investments and equity.
Debt Consolidation The group of any consolidation measures on assets and liabilities. 
Elimination of Unrealized Profit on Inventory The group of any consolidation measures on inventory accounts including an unrealized internal profit.
Expenses and Income Consolidation The group of any consolidation measures on income and expenses, including dividends.
Manual Consolidation Bookings Users can choose to store manual consolidation journal entries in this group (to separate these from automated journal entries) or store the manual journal entries in one of the other groups and leave this element unused.
All Consolidations The sum of all consolidation measures.

The rows show the target elements for the financial consolidation. These are elements of the Scope dimension. See full article.

Total Group This mandatory element represents the total group.
Subgroup (i.e. America) Subgroup elements are subdivisions of the Total Group, i.e. EU and AMER.
All Scopes The aggregation of all Scope elements.