Change profit center hierarchy in group reporting's analysis

[marites26]

Good day experts!

We have quite a number of SAP analysis reports and due to restructuring, we have to change the default profit centre hierarchy.   In the existing reports, the new profit center hierarchy is not visible.  But if I create a new analysis report, I can see the new profit centre hierarchy.  Is there a better and efficient way to change the profit center hierarchy en masse?  Or copy existing analysis reports to create new ones and where presumably I can change the profit centre hierarchy?   

Kind regards,

Tess

[HengyeZhu]

You may explore time dependant hierarchy and change underlying CDS view to handle the key date if change reports are unavoidable. 

[MOHAMMED_BASER]

Hi Tess,
As you explain you have quite number of SAP analysis reports. To efficiently update SAP analysis reports with the new profit center hierarchy, the best approach is to use the “Manage Global Hierarchies” app and recreate or copy reports using the updated hierarchy.

Please find below the best option from best practices.

The Efficient Ways to Update Profit Center Hierarchies are mentioned below.

1. Use the “Manage Global Hierarchies” Fiori App
This app allows you to edit and restructure profit center hierarchies centrally.
Changes made here will reflect in new reports and any apps that dynamically pull from the global hierarchy.
However, existing reports may not auto-update unless they are configured to reference the hierarchy dynamically.

2. Copy Existing Reports and Reassign Hierarchy
Since new reports show the updated hierarchy, copying existing reports and assigning the new hierarchy is a practical workaround.
This ensures that the structure is preserved while aligning with the new hierarchy.
Depending on your SAP version and reporting tool (e.g., SAC, Fiori, BW), you may use:
“Save As” or “Copy” functionality in the report designer
Adjust the data source or hierarchy reference during copy

3. Mass Update via API or Backend Tools
SAP provides APIs and backend tools to update profit center assignments in bulk.
For example, using the Profit Center Group and Hierarchy API, you can asynchronously update hierarchy nodes.
This is ideal for large-scale changes but may require coordination with your SAP technical team.

I will recommend auditing your existing reports to identify which ones are hardcoded to the old hierarchy.
Use the “Manage Global Hierarchies” app to ensure the new hierarchy is properly structured and published.
Recreate or copy reports that don’t reflect the new hierarchy and ensure they reference the updated structure.
If you have many reports, consider automating the update using SAP APIs or scripting tools.

Best Regards