Performing Matrix Consolidation

Objectives

After completing this lesson, you will be able to:

  • Perform matrix consolidation

Management Consolidation Use Case

Matrix consolidation key points

In the corporate close process, we've run the intercompany elimination tasks and now we can report on the results. We need reports that show the performance from a management perspective as well as from a legal perspective. For example, legal reports are by consolidation unit but management reports are by profit center or segment.

In addition, we have a business requirement to view income statement data with a consolidation view as compared to a contribution view:

  • The consolidation view will show total revenue by entity along with an elimination entity (for each consolidation unit hierarchy node).
  • The contribution view shows revenue net of eliminations by entity.
Note
The term matrix consolidation refers to the concept of preparing legal and management consolidated data simultaneously. Group reporting provides multiple views of the data to answer many different business questions. There's only one set of data, therefore there's no data redundancy.

In the Consolidation unit consolidation and contribution view example, we're reporting on consolidation unit revenue with the contribution view and the consolidation view. The same hierarchy is being used for both views. The consolidation view dynamically determines the elimination entity based on the first common parent in the legal hierarchy.

Each view uses a different dimension:

  • Contribution view uses the Consolidation Unit dimension.
  • Consolidation view uses the Consolidation Unit for Elimination dimension.

Matrix Report Examples

In the following content, you’ll see an example of how to create multiple reports on a single set of data to answer multiple business questions.

In the Profit center - consolidation and contribution views example, we're reporting on profit center revenue with the contribution view and the consolidation view. The same hierarchy is being used for both views. The consolidation view dynamically determines the elimination entity based on the first common parent in the line-of-business hierarchy.

Each view uses a different dimension:

  • Contribution view - uses the Profit Center dimension.
  • Consolidation view - uses the Profit Center for Elimination dimension.

When analyzing management entity data, you can use either the Profit Center dimension for a contribution view or the Profit Center for Elimination dimension for a consolidated view. In order to do this, the relevant profit center hierarchy must be selected via the report prompts.

In addition, Segment and Partner Segment can also be used for evaluation of management consolidation data.

In the Elimination entity determination with two different hierarchies example, the consolidation view (total revenue by entity along with an elimination entity for each consolidation unit hierarchy node) is provided by using two different hierarchies:

  • Legal hierarchy: Elimination entities are dynamically determined via the parent nodes in the legal hierarchy.
  • Line-of-business (LOB) hierarchy: Elimination entities are dynamically determined via the parent nodes in the line-of-business hierarchy.

In summary, legal consolidation data can be evaluated with a legal-oriented consolidation unit hierarchy. An alternative hierarchy by line-of- business can also be used to provide a management perspective. In either case, the first common parent in each hierarchy will display the elimination values dynamically. And, because the calculation is on-the-fly, there’s no duplication of data.

Elimination Entity Documents

When reporting on data by consolidation unit for elimination or profit center for elimination, you can jump to the underlying documents to view the dynamically determined elimination entities.

You can also view the elimination entity values by running the Display Group Journal Entries with Reporting Logic app. In either case, hierarchies must be selected for the consolidation unit and profit center/segment dimensions.

In the following scenario, you need to solve a business scenario. Note: There's no audio with this interaction.

Analyze Intercompany Eliminations with Microsoft Excel

Business Scenario

Intercompany revenue and cost for the consolidation units as well as the profit centers have been eliminated. Now, you need to run reports from a legal reporting perspective by consolidation unit and from a management reporting perspective by profit center. The business requirement is to display revenue data by entity from both a contribution and consolidation perspective.

What skills will you develop in this practice exercise?

  • Open SAP Analysis for Office
  • Report on the eliminated data from a legal reporting perspective by consolidation unit
  • Report on the eliminated data from a management reporting perspective by profit center

Log in to track your progress & complete quizzes