Group Reporting Whitepaper Part 1: Matrix Consolidation in Group Reporting: An Introduction
Authored by: Michael Goldman, Senior Principal Consultant at TruQua, an IBM Company
Introduction
Beginning with the 19xx versions of SAP’s S/4HANA for Group Reporting software (“GR”), SAP changed GR’s reporting functionality to support a more “intelligent” reporting logic approach. All GR releases support a full “legal” oriented financial consolidation based on the principle of consolidation groups containing an underlying entity dimension made up of companies. However, most corporations also have additional consolidated reporting requirements where reporting is needed both for reorganizations as well as for “managerial” oriented views of eliminated data along other dimensions like profit centers or segments. With the new reporting logic, GR supports these types of managerial analyses using its “Matrix Consolidation” features. This lets GR report multiple views of the same set of consolidated data by producing on-the-fly eliminated reporting beyond a consolidation group for the consolidation unit, profit center, or segment characteristics. It does this by using “virtual” elimination entities in a “first common parent” hierarchical approach when running reports.
To learn more about Matrix Consolidation in SAP Group Reporting, download our whitepaper below.