SAP Group Reporting: Matrix Consolidation

[former_member131829]

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:   Field Name Enable Inputs Enable Master Data Enable Hierarchy Enable Hierarchy Elimination Aggregate on Carryforward ProfitCenter √ √ √ √ Segment √ √ √ √ PartnerProfitCenter √ √ √ PartnerSegment √ √ √   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:   Field Name Enable Inputs Enable Master Data Enable Hierarchy Enable Hierarchy Elimination Aggregate on Carryforward ProfitCenter √ √ √ √ Segment √ √ √ √ PartnerProfitCenter √ √ √ PartnerSegment √ √ √   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:

1. PC0005 moves from LOBB00 to LOBA00.


2. PC0007 moves from LOBB00 to LOBC00.


3. 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.   Note Adjust original hierarchy structure to valid to 01/31/2022 when encountering activation error The time frame of the new version is overlapping to an existing version.	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.   Note Adjust original hierarchy structure to valid to 01/31/2022 when encountering activation error: The time frame of the new version is overlapping to an existing version.	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 .   Note You can only choose the hierarchy specified in the Prompts to enable management elimination view. The BRD hierarchy for profit centers does not work for management elimination when the Line of Business hierarchy is specified in your prompts.   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.