.svg)
Streamlining Work Order Tracking with SAP Datasphere Integration
A Canadian integrated energy company, it focuses on the production of synthetic crude from oil sands, along with conventional oil and gas, refining, and distribution through retail and wholesale channels.
The company lacked a clear and efficient way to track and compare planned vs. actual hours booked against work orders at the project level. The cost center owners needed better visibility to monitor project progress and identify discrepancies between planned and actual hours, which impacted decision-making and resource management.
A real-time solution where every hour the data gets synced, producing accurate reports.
- 01 Project Information
- 02 The Challenge
- 03 The Solution
- 04 The Results
Project Information
The Integrated Energy Company lacked a clear and efficient way to track and compare planned vs. actual hours booked against work orders at the project level. The cost center owners needed better visibility to monitor project progress and identify discrepancies between planned and actual hours, which impacted decision-making and resource management.
The Challenge
The energy company had some info was in S/4HANA (planned hrs) and some was in FieldGlass (actual hrs) and they needed to bring it together in Datasphere in order to get a total picture of how the actual hours were comparing to the planned hrs on work orders so that they could adjust as needed - plan better, release workers that aren't needed, pinppoint overspending, etc. The SAC report surfaces these data points side by side.
The Solution
The project involved integrating Fieldglass with SAP Datasphere to automate the transfer of actual hours booked against work orders. Key elements of the solution included:
- Fieldglass Integration: Leveraging the ConvergentIS Data Connector within the SAP BTP Integration Suite to import timesheet data from Fieldglass into Datasphere.
- Single Sign-On (SSO) and Connectivity: Ensuring seamless data flow between Fieldglass, Datasphere, and SAP Analytics Cloud (SAC).
- Procurement Analytics Solution: The above solution was built using the ConvergentIS Procurement Analytics Solution, which provided the framework for integrating procurement data and analytics within Datasphere.
- Environment Setup: Implementing Datasphere environments for development, quality assurance, and production.
- SAP Analytics Cloud (SAC): Developing dashboards and reports to provide clear visibility into planned vs. actual hours for work orders, with drill-down capabilities for detailed time entry analysis.
- Data Reconciliation: Building an interface reconciliation report to verify data consistency between Fieldglass and Datasphere.
The Results
- Improved Visibility: Cost center owners now have clear, real-time insights into planned vs. actual hours for each work order, improving project tracking and resource management.
- Data Accuracy: The reconciliation process ensures no data is lost in the transfer between systems, ensuring reliable reporting.
- Streamlined Operations: Automation of timesheet data transfer between Fieldglass and Datasphere reduced manual effort and increased operational efficiency.
- Actionable Insights: The SAC dashboard provides an easy-to-use interface with detailed reporting capabilities, allowing teams to quickly identify and address discrepancies.
Why ConvergentIS?
Our team comes from a variety of different operational backgrounds, meaning we understand how people work. We recognize SAP S/4HANA as an out-of-the-box solution that has successfully solved business problems across several industries. But we realize some work processes are still challenging to learn with so many capabilities available in SAP.
Leveraging the SAP design methodology, we have co-innovated with organizations to build solutions that match the way they work. Since many teams face the same problems, we packaged them and made them available as an out-of-the-box application. This means your business still receives many of the benefits of a tailored application without the cost of a custom solution.
-1.png?width=300&name=Copy%20of%20ConvergentIS%20Values%20(1)-1.png)