Belgian manufacturer achieves rapid post-merger BI integration

Bart Cousin, business intelligence solutions executive at British American Tobacco Belgium, has overseen implementation of an enterprise data management solution from Kalido that essentially yielded a futureproof, flexible data warehouse that accommodates numerous systems data feeds to generate consolidated post-merger reports. Kalido is ensuring compatibility during an ongoing SAP convergence program.

12/12/2007


When Brussels-based cigarette manufacturer British American Tobacco Belgium merged its operations with those of sister company STC —a manufacturer of rolling tobacco, cigars, and smoking materials—it found an urgent need for a business intelligence (BI) solution that would give it a single consolidated view of its performance in an intensely competitive marketplace.
The problem: While each business had its own instance of SAP , and its own implementation of Business Objects ’ business intelligence solution on its own custom-built Oracle data warehouse, there were significant differences in how those systems were configured and used, and even bigger differences in the definitions, business models, and reporting time frames that lay behind them.
Yet with the sales of flagship brands like Kent, Dunhill, Lucky Strike, and Pall Mall at stake, executives realized that a failure to get a handle on market data quickly enough could lead to millions of euro in lost revenue. “Simply combining the figures wasn’t an option,” says Bart Cousin, business intelligence solutions executive at British American Tobacco Belgium. “We’d merged the businesses, but couldn’t simply merge the data.”
A number of potential solutions quickly emerged. SAP’s own Business Information Warehouse, for example, was quickly eliminated as an option, as the majority of the data for the data warehouse would come from non-SAP sources. Another option—put forward by executives from the STC side of the merged business—was to leverage the now-merged company’s considerable experience with custom-built Oracle data warehouses, and develop still another data warehouse, this time combining the operations of the two businesses.
While superficially attractive, the plan failed two critical tests, says Cousin. First, it was likely that it would be costly to develop and maintain, requiring in-depth reengineering every time the business model changed. Second, time was of the essence. “There just wasn’t the time to develop a whole new data warehouse,” says Cousin. “We needed something in a much faster time scale.”
That something turned out to be a solution from enterprise data management vendor Kalido , in the shape of a new data warehouse together with its Universe Manager for Business Objects integration application. The Universe Manager application, says James Dobson, a Kalido senior consultant who was close to the resulting implementation, “is in effect an‘add-on’ to the data warehouse, acting as a Rosetta Stone between the reports that users require, and the underlying data that goes to make up those reports.”
Key to the decision, says Cousin, was the sheer speed with which the Kalido solution could be delivered. Doubt about the viability of the Kalido proposal prompted British American Tobacco Belgium to request a Proof of Value—in effect, a scaled-down pilot of the project—as a result of which a partial working solution was delivered in just five days, drawing data from each of the two SAP systems, and producing meaningful reports. “We had been skeptical, but by the end of the Proof of Value, we were convinced,” says Cousin. “The Kalido concept was technically feasible—and could deliver on its promise far sooner than anything else we were contemplating.”
Also impressive was the ease with which the Kalido solution could subsequently be amended—and amended by ordinary users—as changes to the business model took place. Thanks to the tight integration with Business Objects, substantial cost savings were expected in the maintenance and support of the system—and by eliminating the need for IT experts such as Oracle database administrators, the Kalido solution could enable British American Tobacco Belgium to cut costs by 50 percent.
Following the successful Proof of Value—which had been created by Kalido staff—the project was completed by British American Tobacco Belgium’s own business intelligence team, delivering a full reporting suite on-time and on-budget in just two months. The diverse feeds which previously populated the now redundant Oracle data warehouses were all fed into the Kalido warehouse alongside further feeds from the two SAP systems—all without reengineering any of the source systems. “This would have been impossible to achieve with any of the other solutions, including a custom build,” says Cousin.
The business benefits of the new solution have been significant, he adds, and have provided additional insight to the company’s supply chain and sales operations. And the flexibility of being able to change the data across its diverse source systems means company executives get consistent, accurate and up-to-date information that allows them to track sales performance and monitor market share on a daily basis.
“The project has impressed on every criterion—speed of delivery, budget and all-around capability,” sums up Martin Karlsson, head of IT at British American Tobacco Belgium. “Kalido has enabled us to deliver a futureproof, flexible data warehouse that takes a number of different source feeds, produced bulletproof consolidated post-merger reports and ensured compatibility with our ongoing SAP convergence program.”





No comments
The Top Plant program honors outstanding manufacturing facilities in North America. View the 2013 Top Plant.
The Product of the Year program recognizes products newly released in the manufacturing industries.
The Engineering Leaders Under 40 program identifies and gives recognition to young engineers who...
The true cost of lubrication: Three keys to consider when evaluating oils; Plant Engineering Lubrication Guide; 11 ways to protect bearing assets; Is lubrication part of your KPIs?
Contract maintenance: 5 ways to keep things humming while keeping an eye on costs; Pneumatic systems; Energy monitoring; The sixth 'S' is safety
Transport your data: Supply chain information critical to operational excellence; High-voltage faults; Portable cooling; Safety automation isn't automatic
Case Study Database

Case Study Database

Get more exposure for your case study by uploading it to the Plant Engineering case study database, where end-users can identify relevant solutions and explore what the experts are doing to effectively implement a variety of technology and productivity related projects.

These case studies provide examples of how knowledgeable solution providers have used technology, processes and people to create effective and successful implementations in real-world situations. Case studies can be completed by filling out a simple online form where you can outline the project title, abstract, and full story in 1500 words or less; upload photos, videos and a logo.

Click here to visit the Case Study Database and upload your case study.

Maintaining low data center PUE; Using eco mode in UPS systems; Commissioning electrical and power systems; Exploring dc power distribution alternatives
Synchronizing industrial Ethernet networks; Selecting protocol conversion gateways; Integrating HMIs with PLCs and PACs
Why manufacturers need to see energy in a different light: Current approaches to energy management yield quick savings, but leave plant managers searching for ways of improving on those early gains.

Annual Salary Survey

Participate in the 2013 Salary Survey

In a year when manufacturing continued to lead the economic rebound, it makes sense that plant manager bonuses rebounded. Plant Engineering’s annual Salary Survey shows both wages and bonuses rose in 2012 after a retreat the year before.

Average salary across all job titles for plant floor management rose 3.5% to $95,446, and bonus compensation jumped to $15,162, a 4.2% increase from the 2010 level and double the 2011 total, which showed a sharp drop in bonus.

2012 Salary Survey Analysis

2012 Salary Survey Results

Maintenance and reliability tips and best practices from the maintenance and reliability coaches at Allied Reliability Group.
The One Voice for Manufacturing blog reports on federal public policy issues impacting the manufacturing sector. One Voice is a joint effort by the National Tooling and Machining...
The Society for Maintenance and Reliability Professionals an organization devoted...
Join this ongoing discussion of machine guarding topics, including solutions assessments, regulatory compliance, gap analysis...
IMS Research, recently acquired by IHS Inc., is a leading independent supplier of market research and consultancy to the global electronics industry.
Maintenance is not optional in manufacturing. It’s a profit center, driving productivity and uptime while reducing overall repair costs.
The Lachance on CMMS blog is about current maintenance topics. Blogger Paul Lachance is president and chief technology officer for Smartware Group.