Product Information
SAP Group Reporting: Matrix Consolidation
With this blog, I would like to help you understand the functionality about matrix consolidation features in Group Reporting, and which activities can be run as standard Group Reporting processes to see matrix consolidated results.
From CE2402/OP2024 on, the scope item 3LX(Group Reporting – Matrix Consolidation) is deprecated, but with the information shared in this blog, you still can set it up yourselves by making use of SSCUI apps, and all features are still available to support this scenario.
You will find the following information in this blog:
- Introduction
- Roles
- Preliminary Steps
- Procedures
Introduction
Matrix consolidation covers consolidation for management-oriented organizational units such as profit center and business segment. This functionality addresses the needs of business unit managers and group controllers who need to respond rapidly to changes resulting from internal organization unit restructuring and who need to focus on specific internal performance figures and not the entire group financial statement.
Matrix consolidation introduces new reporting dimensions that are derived at report run-time and not persisted in the universal journal. These virtual organizational units allow the reporting user to show inter-unit eliminations at the correct hierarchy level.
The matrix consolidation is only available for net new installations for 1902.
Customers with initial installation prior to 1902 can’t use this matrix consolidation as the main restriction of SAP S/4HANA group reporting cloud edition 1902.
The key features in this release include:
- Management elimination for the objects’ consolidation unit, profit center and segment
- Enhanced reclassifications by supporting flipping profit center (segment) and partner profit center (partner segment)
- Flexible management consolidation reports generated at report run-time.
You may refer to the below detail procedure which is for matrix consolidation SAP S/4HANA Cloud, public edition, after you activate the scope item 1SG(Group Reporting – Financial Consolidation).
Roles
Create business roles using the following business role templates delivered by SAP and assign them to your individual test users.
Alternatively, if available, you can use the following spaces delivered by SAP. You create a space with pages containing predefined essential apps and assign it to the business role. You then assign this business role to your individual users.
For more information, refer to How to Create a Business Role from a Template in the product assistance for SAP S/4HANA Cloud.
| Name (Role Template) | ID (Role Template) | Name (Launchpad Space) | ID (Launchpad Space) | Log On |
| General Ledger Accountant – Group Reporting | SAP_BR_GL_ACCOUNTANT_GRP | General Ledger Accountant – Group Reporting | SAP_BR_GL_ACCOUNTANT_GRP |
Ask your system administrator to assign to the testers. Generic User: G/L Accountant – Group Reporting |
| Business Analyst – Group Reporting | SAP_BR_BUSINESS_ANALYST_GRP | Business Analyst – Group Reporting | SAP_BR_BUSINESS_ANALYST_GRP |
Ask your system administrator to assign to the testers. Generic User:Analyst – Group Reporting |
Preliminary Steps
Before you start process testing, some manual steps are necessary to complete the system settings.
Depending on your configuration environment for SAP S/4HANA Cloud, choose one of the following options:
Configure Your Solution:
| Test Step # | Test Step Name | Instruction | Expected Result | Pass / Fail / Comment | ||||||||||||||||||||||||||||||
| 1 | Log On | Log on to the SAP Fiori launchpad as a Configuration Expert – Business Process Configuration. | The SAP Fiori launchpad is displayed. | |||||||||||||||||||||||||||||||
| 2 | Access the SAP Fiori App | Choose Manage Your Solution (F1241). | The Manage Your Solution view displays. | |||||||||||||||||||||||||||||||
| 3 | Configure Your Solution | Choose Configure Your Solution. | A Configure Your Solution view displays with an All Items table. | |||||||||||||||||||||||||||||||
| 4 | Enter Search Criteria |
Filter the items list by entering the following: Application Area: Finance Sub Application Area: Corporate Close |
The All Items list is automatically filtered. | |||||||||||||||||||||||||||||||
| 5 | Select Master Data | Choose Master Data. | A Master Data view displays. | |||||||||||||||||||||||||||||||
| 6 | Open Define Consolidation Master Data Fields | Select configuration step Define Consolidation Master Data Fields and choose Configure. | The Change View “Configuration of Additional Characteristics”: Overview view displays. | |||||||||||||||||||||||||||||||
| 7 | Define Additional Consolidation Master Data |
Make or verify that entries for the additional characteristics are configured as described in the following table:
and choose Save at the bottom of the view. |
Configuration of additional characteristics is completed. |
SAP Central Business Configuration:
| Test Step # | Test Step Name | Instruction | Expected Result | Pass / Fail / Comment | ||||||||||||||||||||||||||||||
| 1 | Log On | Log on to the project experience in SAP Central Business Configuration. | ||||||||||||||||||||||||||||||||
| 2 | Open Define Consolidation Master Data Fields |
In the Product-Specific Configuration phase, navigate to the Configuration Activities tab. To locate the activity in the tree view, search for the following activity: Define Consolidation Master Data Fields. Choose Open Documentation for the found line item to see more details about this configuration activity. Choose the link to navigate directly to the SAP S/4HANA Cloud system. Log on to the SAP Fiori launchpad as a Configuration Expert – Business Process Configuration. |
The Define Consolidation Master Data Fields screen displays. | |||||||||||||||||||||||||||||||
| 3 | Define Additional Consolidation Master Data |
Make or verify that entries for the additional characteristics are configured as described in the following table:
and choose Save at the bottom of the view. |
Configuration of additional characteristics is completed. |
Procedures
It is necessary to run through legal consolidation actuals of rule-based COI in 1SG first and then validate the extension matrix consolidation.
The following tables show management consolidation for views of profit center by lines of business or brand and segment.
Lines of Business (Profit Centers)
In 01/2016, corporate has lines of business LOBA00 with PC0001, PC0002, and PC0003 and Line-of-business LOBB00 with PC0004, PC0005, PC0006, PC0007, and LOBC00 underneath. LOBC00 has profit centers PC0008, PC0009, and PC0010.
For 02/2022, Lines of Business undergo reorganization as follows:
- PC0005 moves from LOBB00 to LOBA00.
- PC0007 moves from LOBB00 to LOBC00.
- PC0009 moves from LOBC00 to LOBB00.
Lines of business structure remain unchanged for 03/2022 and all periods after.
| Line of Business (LOB) | 01/2016 | 02/2022 |
| LOBA00 | PC0001 | PC0001 |
| PC0002 | PC0002 | |
| PC0003 | PC0003 | |
| PC0005 | ||
| LOBB00 | PC0004 | PC0004 |
| PC0005 | PC0006 | |
| PC0006 | PC0009 | |
| PC0007 | ||
| LOBC00 | PC0008 | PC0008 |
| PC0009 | PC0007 | |
| PC0010 | PC0010 |
Brand (Profit Centers)
| Brand (BRD) | 01/2022 – 12/9999 |
| BRDA00 | PC0001 |
| PC0005 | |
| PC0009 | |
| PC0010 | |
| BRDB00 | PC0004 |
| PC0006 | |
| PC0007 | |
| BRDC00 | PC0008 |
| PC0002 | |
| PC0003 |
Segment (SEG)
In 02/2022, SE0001 moves from SEGA00 to SEGC00. Segment structure remains unchanged for 03/2022 and all periods after.
| Segment (SEG) | 01/2016 | 02/2022 |
| SEGA00 | SE0001 | SE0002 |
| SE0002 | ||
| SEGB00 | SE0003 | SE0003 |
| SE0004 | SE0004 | |
| SEGC00 | SE0005 | SE0005 |
| SE0001 |
Region (Consolidation Units)
| Region | 01/2016 – 12/9999 |
| NA | MXX03 |
| MXX04 | |
| EMEA | MXX00 |
| MXX02 | |
| MXX05 | |
| MXX07 | |
| APJ | MXX06 |
| MXX08 |
Create Hierarchies for Additional Master Data in 2016.01
In this activity, you create different management views of consolidation for consolidation units, profit centers, and segment in period 2016.01.
Prerequisites
Here is an attached file that must be saved to your local drive file. Replace the XX in the file with your consolidation unit ID.
Procedure
| Test Step # | Test Step Name | Instruction | Expected Result | Pass / Fail / Comment |
| 1 | Log On | Log on to the SAP Fiori launchpad as General Ledger Accountant – Group Reporting. | The SAP Fiori launchpad displays. | |
| 2 | Access the SAP Fiori App | Open Set Global Parameters (CXGP). | ||
| 3 | Enter Details |
Make the following entries and choose Continue: Cons Group: CGRXX (replace XX with your created group number) Cons Unit: NA Version: Y20 Fiscal Year: 2016 Period: 01 Cons COA: Y1 |
||
| 4 | Home | Choose Home. | ||
| 5 | Access the SAP Fiori App | Open Manage Global Hierarchies (F2918). | The Manage Global Hierarchies view is displayed. | |
| 6 | Enter Criteria |
Enter the following filter entry: Type: Consolidation Profit Center and choose Go. |
The Hierarchy List table displays filtered results. | |
| 7 | Define Hierarchy LOB |
Select the Create (Create a new hierarchy) icon. In the Create New Hierarchy dialog box, enter the following parameters: Type: Consolidation Profit Center Hierachy ID: LOB Controlling Area: A000 Hierarchy Description: Lines of Business Valid From: 01/01/2016 Valid To: 12/31/9999 Choose Create. |
The Create New Hierarchy dialog box is displayed. | |
| 8 | Define BRD Hierarchy |
Create an additional hierarchy by selecting the Create (Create a new hierarchy) icon. In the Create New Hierarchy dialog box, enter the following parameters: Type: Consolidation Profit Center Hierachy ID: BRD Controlling Area: A000 Hierarchy Description: Brand Valid From: 01/01/2016 Valid To: 12/31/9999 Choose Create. |
Profit center hierarchy BRD is created and displays in a Hierarchy List. | |
| 9 | Select Hierarchy | From the Hierarchy List, select the BRD hierarchy. | A BRD – Consolidation Profit Center column displays. | |
| 10 | Import Spreadsheet |
Choose Edit from the bottom of the view. Choose the Export/Import button and select Import from Spreadsheet from the dropdown. |
An Import from Spreadsheet dialog box displays. | |
| 11 | Upload File |
Upload the attached template with hierarchy structure defined and choose Upload File. Choose Save and then choose Activate. |
Structure of profit center hierarchy BRD is updated. | |
| 12 | Repeat for LOB Hierarchy |
On the left column, remove BRD from the Hierarchy ID field and enter LOB and choose Go From the Hierarchy List on the left column, select LOB – Consolidation Profit Center. |
The right column displays the LOB – Consolidation Profit Center hierarchy. | |
| 13 | Import Spreadsheet |
Choose Edit from the bottom of the view. Choose the Export/Import button and select Import from Spreadsheet from the dropdown. |
An Import from Spreadsheet dialog box displays. | |
| 14 | Upload File |
Upload the attached file with hierarchy structure defined and choose Upload File. Choose Save and then Activate the hierarchy. |
Structure of profit center hierarchy LOB is updated. | |
| 15 | Back | Choose the < (Back) button to return to the previous view. | ||
| 16 | Enter Criteria |
Clear all filter entries and then enter the following: Type: Consolidation Segment and choose Go. |
The Hierarchy List table displays the filtered results. | |
| 17 | Define SEG Hierarchy |
Select the Create (Create a new hierarchy) icon. In the Create New Hierarchy dialog box, enter the following parameters: Type: Consolidation Segment Hierarchy ID: SEG Hierarchy Description: Segment Valid From: 01/01/2016 Valid To: 12/31/9999 and choose Create. |
Segment hierarchy SEG is created and displays in a Hierarchy List. | |
| 18 | Select Hierarchy | From the Hierarchy List, select the SEG – Consolidation Segment hierarchy. | The right column displays the SEG – Consolidation Segment hierarchy. | |
| 19 | Import Spreadsheet |
Choose Edit from the bottom of the view. Choose the Export/Import button and select Import from Spreadsheet from the dropdown. |
An Import from Spreadsheet dialog box is displayed. | |
| 20 | Upload File |
Upload the attached template with hierarchy structure defined and then choose Upload file. Choose Save and then Activate the hierarchy SEG. |
Structure of segment hierarchy SEG is updated. | |
| 21 | Back | Choose the < (Back) button to return to the previous view. | ||
| 22 | Enter Criteria |
Clear all filter entries and then enter the following: Type: Consolidation Unit and choose Go. |
The Hierarchy List displays filtered results. | |
| 23 | Define REGION Hierarchy |
Select Create (Create a new hierarchy) and on the Create New Hierarchy dialog box, enter the following parameters: Type: Consolidation Unit Hierarchy ID: REGION Hierarchy Description: Segment Valid From: 01/01/2016 Valid To: 12/31/9999 and choose Create. |
Consolidation unit hierarchy REGION is created. | |
| 24 | Select Hierarchy | From the Hierarchy List, select the REGION – Consolidation Unit hierarchy. | The right column displays the REGION – Consolidation Unit hierarchy. | |
| 25 | Import Spreadsheet |
Choose Edit from the bottom of the view. Choose the Export/Import button and select Import from Spreadsheet from the dropdown. |
An Import from Spreadsheet dialog box is displayed. | |
| 26 | Upload |
As instructed in the Prerequisites, you have uploaded the attached file to local drive and replace XX with your consolidation unit ID. Upload your updated local template and choose Upload file. Choose Save and then Activate the hierarchy region. |
Structure of consolidation unit hierarchy Region is updated. |
Update Management Views in 2022.02
In this activity, the profit center hierarchy LOB and segment hierarchy SEG are restructured in period 2022.02.
Procedure
| Test Step # | Test Step Name | Instruction | Expected Result | Pass / Fail / Comment | |
| 1 | Log On | Log on to the SAP Fiori launchpad as General Ledger Accountant – Group Reporting. | The SAP Fiori launchpad is displayed. | ||
| 3 | Define Hierarchy | Open Manage Global Hierarchies (F2918). | The Manage Global Hierarchies view is displayed. | ||
| 4 | Enter Filter Criteria |
Make the following entries: Type: Consolidation Profit Center Hierarchy ID: LOB and choose Go. |
The Hierarchy List displays the filter results. | ||
| 5 | Open | Select LOB – Consolidation Profit Center from Hierarchy List. | The LOB – Consolidation Profit Center view displays in the right column. | ||
| 6 | Copy to Existing Hierarchy | From the bottom of the view, choose Copy and select To Existing Hierarchy from the dropdown. | The Copy to Existing Hierarchy dialog box is displayed. | ||
| 7 | Copy |
Enter the following parameters: Valid From: 02/01/2022 and choose Copy. |
The update is copied. | ||
| 8 | Restructure LOB Profit Center Hierarchy |
Choose the newly copied consolidation profit center from the left. From the bottom of the view, choose Edit. Expand all of the nodes of the hierarchy. Drag and drop: PC0005 from LOBB00 to LOBA00 PC0007 from LOBB00 to LOBC00 PC0009 from LOBC00 to LOBB00. Choose Save and then choose Activate. Choose Back.
|
Structure of profit center hierarchy LOB is updated. | ||
| 9 | Back | Choose the < (Back) button to return to the previous view. | |||
| 10 | Select Filter Criteria |
Clear all filter entries and then enter the following: Type: Consolidation Segment Hierarchy ID: SEG and choose Go. |
The Hierarchy List displays with the filtered results. | ||
| 11 | Select SEG Hierarchy | Select SEG – Consolidation Segment from the hierarchy list. | A SEG – Consolidation Segment view displays in the right column. | ||
| 12 | Copy to Existing Hierarchy | From the bottom of the view, choose Copy and then select To Existing Hierarchy from the dropdown. | A Copy to Existing Hierarchy dialog box is displayed. | ||
| 13 | Copy |
Enter the following parameters: Valid From: 02/01/2022 and choose Copy. |
The update is copied. | ||
| 14 | Restructure SEG Consolidation Segment Hierarchy |
Choose the newly copied consolidation segment from the left. From the bottom of the view, choose Edit and then expand all of the nodes of the hierarchy. Drag and drop the following: SE0001 from SEGA00 to SEGC00. Choose Save and then choose Activate.
|
Structure of segment SEG is updated. | ||
| 15 | Back | Choose < (Back) to return to Manage Global Hierarchies view. | Update is completed. |
Reporting
The following reports are provided to specific, selected FS items:
- By scope and consolidation unit hierarchy Region
- By scope and profit centers hierarchy LOB
- By scope and profit centers hierarchy BRD
- By scope and segment hierarchy SEG
- By any other combinations of management views
Procedure
| Test Step # | Test Step Name | Instruction | Expected Result | Pass / Fail / Comment | |
| 1 | Log On | Log on to the SAP Fiori launchpad as Business Analyst – Group Reporting. | The SAP Fiori launchpad is displayed. | ||
| 2 | Matrix Consolidation Analysis | Open Group Data Analysis (W0135). | The Group Data Analysis view is displayed. | ||
| 3 | Enter Criteria |
Enter the following selections: Version: for example, A10 <the version used in 1SG> Consolidation COA: Y1 Fiscal Year Period: 001/2022 Consolidation Group: <For example,CGRXX, (replace the XX with your group)> Period Mode: YTD Key Date: 01/31/2022 Consolidation Unit Hierarchy: $ Profit Center Hierarchy: <For example, $> Segment Hierarchy: <For example, $> and choose Go. |
The navigation panel updates with results from criteria. | ||
| 4 | Back | Return to the Home view of the SAP Fiori launchpad. | |||
| 5 | Access the SAP Fiori App | Open Group Data Analysis – With Reporting Rules (W0136) | A Prompts dialog box is displayed. | ||
| 6 | Enter Criteria |
Enter the following selections: Version: A10 Consolidation COA: Y1 Fiscal Year Period: 001/2022 Consolidation Group: <For example,CGRXX, (replace the XX with your group)> Period Mode: YTD Key Date: 01/31/2022 Consolidation Unit Hierarchy: <For example, $> Profit Center Hierarchy: <For example, $> Segment Hierarchy: <For example, $> Rep. Item Hierarchy: X1 Reporting Rule Var.: Y10 and choose Go. |
The Group Data Analysis – With Reporting Rules view is displayed. | ||
| 7 | Analysis View by Profit Centers |
Choose Navigation Panel on the top left. In the Columns area, remove other fields to keep only Fiscal Year, Fiscal Period, Period mode, and Measures in the list. From Available Fields, find the Profit Center for Elimination field and drag and drop into Rows to change the display of the report. Right-click the Profit Center for Elimination field in Rows in the navigation panel and choose Hierarchy > Select Hierarchy . Choose item hierarchy Lines of Business and choose OK. Right-click the Profit Center Elimination row header and choose Hierarchy > Expand All .
To save this layout as your default view, choose <Standard Query View> arrow above the report body and in the My Views dialog box, choose Save As. In the Save View dialog box, enter a name, and select the Save as Default checkbox. Select the Public checkbox to allow other users to reuse this view and choose OK. You can also add this view as a tile in Group by running the report in this view, and select Actions on the right in the menu bar and choose Save as Tile. You have the option to add this new tile to Group reports instead of default value Home. |
Management consolidation analysis view for profit center is generated. | ||
| 8 | Analysis View by Profit Centers and Segment |
Now drag the Segment for Elimination dimension to Rows. Right-click the Segment for Elimination field and choose Hierarchy > Select Hierarchy , and then select Segment and choose OK. Right-click Segment for Elimination row header and choose Hierarchy > Expand All . |
Consolidation analysis view for profit center and segment is generated. | ||
| 9 | Analysis View by Scope, Profit Centers, and Segment | Now drag the Consolidation Group dimension to the Rows axis and add before Profit Center for Elimination. | An analysis view for scope, profit center, and segment is generated. | ||
| 10 | Review Group Journal Entries | Select Navigate to > Display Group Journal Entries With Reporting Logic . | Relevant group journal entries are displayed. | ||
| 11 | Change the Validate Date |
Choose < to go back to the previous Group Data Analysis – With Reporting Rules view. Change following entries: Fiscal Year Period: 002/2022 Key Date: 02/28/2022 Choose Go to display the view. |
Line of business and segment structures are updated. | ||
| 12 | Return to the SAP Fiori launchpad | Return to the SAP Fiori launchpad. |
Now, you can start deploying your solution and running the matrix consolidation. We hope you’ll find this blog useful.