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 2015 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...
Strategic outsourcing delivers efficiency; Sleeve bearing clearance; Causes of water hammer; Improve air quality; Maintenance safety; GAMS preview
World-class maintenance: The three keys to success - Deploy people, process and technology; 2016 Lubrication Guide; Why hydraulic systems get hot
Your leaks start here: Take a disciplined approach with your hydraulic system; U.S. presence at Hannover Messe a rousing success
Flexible offshore fire protection; Big Data's impact on operations; Bridging the skills gap; Identifying security risks
The digital oilfield: Utilizing Big Data can yield big savings; Virtualization a real solution; Tracking SIS performance
Getting to the bottom of subsea repairs: Older pipelines need more attention, and operators need a repair strategy; OTC preview; Offshore production difficult - and crucial
Applying network redundancy; Overcoming loop tuning challenges; PID control and networks
Putting COPS into context; Designing medium-voltage electrical systems; Planning and designing resilient, efficient data centers; The nine steps of designing generator fuel systems
Package boilers; Natural gas infrared heating; Thermal treasure; Standby generation; Natural gas supports green efforts

Annual Salary Survey

Before the calendar turned, 2016 already had the makings of a pivotal year for manufacturing, and for the world.

There were the big events for the year, including the United States as Partner Country at Hannover Messe in April and the 2016 International Manufacturing Technology Show in Chicago in September. There's also the matter of the U.S. presidential elections in November, which promise to shape policy in manufacturing for years to come.

But the year started with global economic turmoil, as a slowdown in Chinese manufacturing triggered a worldwide stock hiccup that sent values plummeting. The continued plunge in world oil prices has resulted in a slowdown in exploration and, by extension, the manufacture of exploration equipment.

Read more: 2015 Salary Survey

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.
This article collection contains several articles on the vital role that compressed air plays in manufacturing plants.
This article collection contains several articles on the Industrial Internet of Things (IIoT) and how it is transforming manufacturing.
This article collection contains several articles on strategic maintenance and understanding all the parts of your plant.
click me