|Case Study: Dyno Nobel SAP BW Management Reporting|
By Eckart Altenkamp
Dyno Nobel, the Explosives business of Incitec Pivot Limited, is a global leader in the commercial explosives industry. We provide blasting solutions and quality explosives products throughout North America and Australia, as well as to selected customers in other countries.
They have 36 manufacturing plants, including state-of-the-art initiation systems facilities in the United States, Australia and Mexico, and have the capacity to make one million tons of ammonium nitrate a year. Our employees include some of the most highly trained blasters in the industry.
Dyno Nobel traces its roots back to William Bickford's invention of Safety Fuse in 1831 and Alfred Nobel's legacy of safety and innovation dating back to 1865. These values form the global teams as they interact with and support customers across the globe
PLAUT was engaged by Dyno Nobel in September 2005 to explore how they could implement a solution to deliver a consolidated view of their financial statements and financial reporting, across many companies globally.
Plaut Solution Used
We spent time with the business to understand in detail what their requirements were and to make sure we knew what the outcome they expected was. The solution we decided to implement was based on SAP’s Business Intelligence platform, utilizing the SAP Business Information Warehouse to consolidate, normalize and build relationships between the various data elements and the actual SAP component SEM-BCS to apply the consolidation rules and produce the reporting framework required for a global organization. This project provided a financial consolidation solution for their global business.
The solution provided access to data from both SAP (R/3, SEM-BCS) and non SAP data in order to provide information for Statutory reporting, Management reporting, Operational reporting and Strategic decision making. All global Dyno Nobel users access company wide reports and documents via SAP Portal. The same reports (controlled by Authorization) are used by all business functions, geographies and levels of responsibility. With this approach, users will have the same report layout and report definition.
Reports are created by using WAD (Web Application Designer) to make sure that all reports will have the same look, feel and functionality for ‘Slice, dice and drilldown’ capabilities.
Reports have a comment area for users to maintain their comment to describe a pre-defined data in a format of table and/or graph. The comment is entered as text or inserted as object (picture, Power Point, etc.) into a comment area.
Reports are organized as below:
1) To display Monthly reports that are available in KM folder on the right hand side
2) To display ‘Broadcast reports’ that users can print reports as a hardcopy or save reports in PDF format.
3) To display a set of reports separated by tab or to maintain comment on screen
The project met all of its objectives:
Consistent with our engagement model of focusing on long term relationships based on high mutual value, we continued to support Dyno Nobel with further refinements to this solution on an ongoing basis. We now also support the business processes in the areas of Finance, MM, PP and SD, have undertaken some strategic Plant Maintenance work, were able to deploy the SAP Portal to support some of their distributed processes and more recently, we have developed a global HR template for Dyno Nobel’s upcoming HR rollout projects.
The way Dyno continue to engage PLAUT for an increasing number of projects across the SAP Platform is a good indicator of the quality of work we deliver and the trust which has built up between our organizations resulting in an effective and efficient relationship where PLAUT is engaged to provide strategic advice, conduct implementation projects as well as deliver ongoing support services