The situation. tesa has developed pressure-sensitive adhesive tape technologies for more than a century and offers 800 kinds of self-adhesive tape in over fifty countries. In Asia Pacific it runs local sales teams in thirteen countries and storage, production and converting centres in Australia, China, India, Malaysia and Singapore, with the regional head office in Singapore.
The challenge. A new Navision ERP system could generate reports, but its visual capabilities were limited. Before the project, each affiliate sent its data to Singapore in Excel or Access files that had to be loaded by hand into the regional applications. "This was resource-intensive and we were always one step removed from visibility," said Lina Tiong, MIS Manager.
What was built. A sales analysis application for affiliates reporting into the regional head office, pulling directly from the ERP through ODBC. Affiliates in Australia, China, Japan, Malaysia and Singapore pull their own information online for monthly consolidation, and the head office sees profit and margin by office, affiliate, country and product without any manual manipulation. Sales and manufacturing analysis followed.
"QlikView provides flexibility to filter information and merge data from different sources. The visual capabilities are great; we have different and better ways to view information. We can see multiple dimensions with one report, instead of having to build different reports for each sort." — Lina Tiong, MIS Manager, tesa tape Singapore
Results. Reporting time fell and the small IT team was freed for other work. Because tesa's own team was committed to the ERP rollout, consultants from KMS, then operating as QlikView SEA, handled application development and travelled to each office for a day of user training. The goal set at the time was that every subsidiary in the region would report through the application once the ERP rollout completed.
tesa tape consolidates Asia-Pacific sales reporting straight from its ERP