Context
- Customer: Dura-Line
- Project: Dura-Line Data and Analytics Project
- Market: Manufacturing
- Technologies: SAP ECC, SAP BODS, Databricks (Azure), SAP Analytics Cloud
- Time: 2024
Dura-Line reviews the profitability of the business across plants, product groupings, and regions.
One SAP BW report is in use for the North-American business, which is outdated, has gaps and timing issues. Other global regions have manually compiled reports, without aligned definitions.
Requirement summary
The business needs a timely, correct and complete profitability report with a global scope.
It must be on billing document item level, referencing customer- , shipping destination- and material data, as well as delivery number for delivery based revenue.
Solution summary
Compiling billing data
First the needed data is acquired:
- Customer-, material-, plant- and address data is taken from SAP ECC into the Databricks Lakehouse.
- Billing header-, -item- , -busines partner- and -pricing condition data is taken from SAP ECC into the Databricks Lakehouse.
The profitability analysis follows a breakdown from gross revenue to margin by subsequently eliminating freight costs, raw material costs, manufacturing costs.
So, in Databricks, for each billing item, pricing condition values are referenced to calculate balances for freight, raw materials and total costs. Manufacturing costs are calculated by subtracting raw material- and freight costs from the total.
Currency conversion
Using currency conversion data in the billing records, the values are converted to the currency of the issuing company, to assure that the balances tie to the financial administration.
The values in local currency are in turn translated to USD and EUR for regional- and global reporting.
Modeling SAP Analytics Cloud
In SAP Analytic Cloud, an import model is built, with the billing data table as data foundation, and dimensions for:
- Material
- Customer
- Shipping destination
- Plant
- Company code
The data is imported into SAP Analytics Cloud using the JDBC connection to the Databricks Lakehouse.
It is used by the business in Excel, using the SAC plugin, and in the web-version, in business-managed dashboards.
