How to pull global hierarchy from SAP S4 to SAC

Pulling a global hierarchy from SAP S/4HANA to SAP Analytics Cloud (SAC) requires a few steps. Here's how you can do it:

1. Identify the Hierarchy in S/4HANA

• Manage Global Hierarchies App: In S/4HANA, global hierarchies are typically managed using the "Manage Global Hierarchies" Fiori app. This is where you define hierarchies for various objects like GL accounts, cost centers, profit centers, etc.
• Determine Hierarchy Type: Identify the type of hierarchy you need (e.g., GL account hierarchy, cost center hierarchy). This will determine the relevant CDS views or APIs to use.

2. Extract Hierarchy Data

• CDS Views: SAP provides standard CDS views that you can use to extract hierarchy data. The specific CDS view will depend on the type of hierarchy. For example:
  • GL Account Hierarchy: I_GLAccountHierarchy
  • Cost Center Hierarchy: I_CostCenterHierarchy
  • Profit Center Hierarchy: I_ProfitCenterHierarchy
• Custom CDS View: If the standard CDS views don't meet your needs, you can create a custom CDS view to extract the hierarchy data.
• APIs: Alternatively, you can use APIs (e.g., OData services) to extract hierarchy information from S/4HANA.

3. Load Hierarchy into SAC

• Data Connection: Establish a live data connection or an import connection between SAC and your S/4HANA system.
• Import Data:
  • Live Connection: If you're using a live connection, you can directly access the hierarchy data from the CDS view or API in your SAC story.
  • Import Connection: If you're using an import connection, you'll need to import the hierarchy data from the CDS view or API into SAC.
• Create a Dimension: In SAC, create a new dimension to represent the hierarchy.
• Define Hierarchy: Use the imported data to define the hierarchy structure within the dimension in SAC. You can do this manually or by using SAC's hierarchy import functionality.

4. Use the Hierarchy in SAC

• Reporting: Once the hierarchy is loaded into SAC, you can use it in your reports and dashboards for analysis and visualization.
• Filtering and Drill-down: You can filter data based on hierarchy levels and drill down into the hierarchy for more detailed analysis.

Technical Considerations:

• Authorization: Ensure that the SAC user has the required authorizations to access the relevant CDS views or APIs in S/4HANA.
• Performance: Optimize the data extraction and loading process for performance. Consider using delta loads for import connections to minimize data transfer.
• Hierarchy Maintenance: Keep the hierarchy up-to-date in S/4HANA to ensure that your SAC reports reflect the latest organizational structure.

Example (GL Account Hierarchy):

1. In S/4HANA: Use the "Manage Global Hierarchies" app to define your GL account hierarchy.
2. In SAC:
   • Create a live data connection to your S/4HANA system.
   • Create a new dimension in SAC (e.g., "GL Account").
   • Import the hierarchy data from the I_GLAccountHierarchy CDS view.
   • Define the hierarchy structure in the dimension based on the imported data.

By following these steps, you can successfully pull global hierarchies from your SAP S/4HANA system into SAP Analytics Cloud and use them for effective reporting and analysis.