Case Study: Dyno Nobel SAP BW Management Reporting



dyno-nobelBy Eckart Altenkamp

"Using a combination of SAP's BW and Portal technology, a management reporting solution was developed to provide 'one version of the truth' reporting across all business functions and geographies. With simple to use screens and system generated reports, all levels of the organisation were empowered to run their own reports and management able to make strategic decisions with confidence."

Zev Friedman, Dyno Nobel Project Manager

Client
http://www.dynonobel.com

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
Project Objectives

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.

  • Standardised reports that are easy to access, easy to understand and consistent in their look and feel across all Dyno Nobel sites globally.
  • Accurate, timely and consistent Information across all business functions, geographies and levels of responsibility.
  • Provide “One version of the truth” to all users.
Key Challenges

  • Use of SAP Portal to access company wide reports
  • Use of Knowledge Management to produce Monthly Management Reports to Senior Management and Executive Committee
  • Changes to data only in Source System (not in BW)
  • Allow to maintain comment in reports
  • BW generates reports and automatically emails to users
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.

dn-pic-1

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.

dn-pic-2

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.

dn-pic-3

Reports are organized as below:

dn-pic-4
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. dn-pic-5

3) To display a set of reports separated by tab or to maintain comment on screen

dn-pic-6
Outcomes

The project met all of its objectives:
  • Standardised reports that are easy to access, easy to understand and consistent in their look and feel across all Dyno Nobel sites globally.
  • Reports are accessed through SAP portal from any PC (no need to install SAP Gui). Each report has the same look and feel and offers the same functionality for ‘slice, dice & drilldown’ capabilities.
  • Provided accurate, timely and consistent Information across all business functions, geographies and levels of responsibility.
  • Reports are generated via SAP BW (rather than created by data dumps from SAP and manual manipulations in Excel.
  • Reports are scheduled to email to users in specific time.
  • Reports are broadcasted to Knowledge Management Folder in SAP Portal.
  • “One version of the truth” is provided to all users.
  • Reports are accessed via SAP Portal to ensure that BW generated numbers cannot be changed. The change can only be done in SAP R/3.
  • Intangible cost saving of USD $2,345,400 p.a and ROI – 5 months
Given our performance on this assignment Dyno Noble engaged us to deliver a comprehensive management reporting solution based on the SAP BI Platform for the corporate head office in Sydney.

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
Summary

No of Sites
4
No of Users
330
SAP Version
ECC 6 / BI 7
Solution and Services
Business Intelligence
Hardware
HP
Operating System
Windows NT
Database
MSSQL

 

 

site designed and hosted by e-motion design