Industry: Food & Beverage
SAB manages the big picture with help from Wonderware
South Africa Breweries Limited is a vast, geographically-distributed network of breweries involved with complex production processes that have to satisfy the demands of millions of discerning customers in real-time. While this may sound challenging enough for the management of a single brewery, coordinating the efforts of seven manufacturing regions so as to provide an in-depth, unified and comprehensive vies of KPIs was best done with help from an application known as Enterprise Manufacturing Intelligence or EMI
Before this project, there were limited facilities to proactively monitor critical systems in SAB’s beer manufacturing systems department and this led to the requirement for the implementation of a centralised monitoring system that would detect and warn about mission-critical manufacturing systems within SAB that were in difficulty with respect to meeting their KPIs.
Although distributed in nature, manufacturing enterprises such as SAB still need to operate as unified entities with respect to meeting their business objectives and it is in this regard that the company looked for a solution that would provide a collated picture of its production facilities and that made the best use of its existing information assets while providing the least change to operators and users.
Project Dash (short for the dashboard view it was to provide into the individual and collated production facilities of SAB) was started and it had to plug some important information holes by:
- Providing a centralised system for the early detection and warning of mission-critical problems
- Implementing a centralised data repository for analysis purposes
- Identifying key KPIs for PLCs, Wonderware Historian, System Platform and MES hardware and software systems for all seven beer manufacturing regions
- Presenting the information in dashboard format so that it could be easily read, interpreted and viewed from a divisional level at head office.
“We selected Wonderware Intelligence because not only would it provide the functionality we were looking for but it would also fit into SAB’s strategic architecture and alignment with our standardising on the Wonderware Application Server (System Platform),” says Hein du Toit, Business Analyst at SAB Limited. “Buying into suite-based products gives long term value and it also gave us seamless access to time-based Wonderware Historian production data. It also allowed us to plug into MS SQL databases for MES and other applications.”
One of the main functions of any EMI application such as Wonderware Intelligence is to collate data from a wide and often disparate number of sources and to provide data warehousing, data aggregation as well as roll-up and drill-down functionality. But this information is less than helpful if it can’t be displayed in a format that is easy to define and understand. “Wonderware Intelligence provides user-friendly, drag-and-drop dashboarding functionality,” says du Toit. “Once you have explored the Dashboarding tool, Tableau Server, it really does make creating dashboards easy. It is an extremely powerful tool.”
Since it’s an SAB rule that all system integrator work done on the System Platform be performed by ArchestrA-Certified SIs, SAB chose system integrator Advansys for the implementation.
“Wonderware Intelligence provides user-friendly, drag-and-drop dashboarding functionality. Once you have explored the Dashboarding tool, Tableau Server, it really does make creating dashboards easy. It is an extremely powerful tool.” Hein du Toit, Business Analyst at SAB Ltd
The company has a good knowledge of the Food and Beverage industry in general and the brewing industry in particular. “Advansys’ specific advantage is knowledge of not only the beer making process but also the manufacturing system architecture that we use such as our eQMS, which is our quality/MES system,” says du Toit.
In addition, if any custom development had to be done, the expert use of the ArchestrA Application Object Toolkit was important. This gives the ability for any custom development to conform with SAB’s architecture and standards while making it easy for the engineers at regional level to understand and maintain the system.
“Lastly, Wonderware Intelligence is a Business Intelligence tool and Advansys’ knowledge of data warehousing was important to understand and implement the project on a tight timeline,” concludes du Toit.
“Starting at the regional level, we wanted to make use of the existing infrastructure at the regions and did not want to introduce anything that would affect the performance of the historians, application object servers or even the PLCs,” says du Toit.
The project team drew up the required regional system architecture shown in figure 1 which collates KPIs from the PLCs as well as the Historians and MES servers for storage in the regional data warehouse from which it can be extracted and viewed in dashboard form according to the needs of users.
This regional architecture was replicated seven times for each of the regions and connected to the central data warehouse at head office as shown in figure 2 where the dashboard views not only represent an aggregated picture but also allow drilling down to the views of each region independently.
“SAB stipulated that we make use of the existing ArchestrA System Platform install-base, providing centralised change management, change propagation and it’s user-friendly Integrated Development Environment (IDE) for all data retrieval configuration,” says Advansys Director Graeme Welton.
The main reasons for this were that SAB didn’t want another system to maintain and ArchestrA is already the standard system control platform at all the breweries. Systems engineers are familiar with its IDE and the System Platform provides built-in change propagation and object derivation, a deployment installation model as well as an integral security model. In other words, everything was in place to allow Advansys to focus on the Intelligence application and not spend engineering time on fundamentals.
This phase of project Dash focused on collecting and collating diagnostic data with respect to system performance, traffic volumes, CPU usage, scan times, memory usage, message status (MSMQ), I/O Server item counts (total, active, etc.), disc space availability, unprocessed SQL messages and many more. This would include everything from the PLC, Server Platform, the process and the ArchestrA engine to the I/O Server, the file system, Microsoft Message Queue and any SQL database (MES).
“Because of the nature of this data, most of which comes from operating system diagnostics, as well as SAB’s requirement to use ArchestrA, we decided to use the ArchestrA Object Toolkit which gave us full use of the ArchestrA Object Framework and access to low-level C#.Net coding,” says Welton. “This approach also allowed us to use standard, out-of-the-box alarm and history primitives and compile editors for easy configuration. This all meant that no scripting was required for engineers to configure the data retrieval objects.”
Welton believes that the dashboard development tool is much more than it appears at first and that Wonderware have produced a solution whereby almost anyone with some basic training can collect and collate information from virtually any combination of sources to suit their needs. “This is rather different to traditional Business Intelligence tools that require large IT teams to support and develop.”
“I feel I should comment on three important aspects of the project,” says du Toit. “First of all, time; after the testing and development phase, we were able to roll out the project to the rest of the sites and commission within 2 months! This is a reflection on the power of the underlying ArchestrA technology. Then there’s the matter of cost. The time saved with the project roll-out had a direct impact on the cost and we were able to finish within budget. The third point is the exceptional quality of the work delivered by Advansys.”
- One immediate benefit was risk reduction. With an immediate view of the status of each system, engineers were able to detect issues that impact performance of the various systems under scrutiny.
- Cross platform comparison and analysis makes decision making easy when deciding on deployment of areas.
- Cross-regional analysis shows trends and areas to focus on for development or where support should be given.
“I believe that the dashboard development tool is much more than it appears at first and that Wonderware have produced a solution whereby almost anyone with some basic training can collect and collate information from virtually any combination of sources. This is rather different to typical Business Intelligence tools that require large IT teams to support and develop.” Graeme Welton, Director, Advansys
About The South African Breweries Limited (SAB)
Founded in 1895, SAB is the South African subsidiary and historical birthplace of SABMiller plc, one of the world’s largest brewers by volume with more than 200 brands and brewing interests and distribution agreements in over 60 countries across six continents.
SAB is the second largest listed company on the JSE Securities Exchange, South Africa’s leading producer and distributor of alcoholic and non-alcoholic beverages and one of the nation’s largest manufacturing firms.
The company operates seven breweries and 42 depots in South Africa with an annual brewing capacity of 3.1 billion litres. Its portfolio of beer brands meets the needs of a wide range of consumers and includes brands rich in heritage such as Castle Lager, Hansa Pilsner, Carling Black Label and the iconic Dutch beer brand Grolsch.
SAB employs more than 9,000 people, 75% of whom are from previously disadvantaged groups. In addition SAB’s operations support an estimated 48,000 jobs at SAB’s first round suppliers. For each job offered by SAB and its first round suppliers, 5.7 additional jobs are supported in the rest of the South African economy. In all 378,000 full time jobs in South Africa can directly or indirectly be traced back to the production of SAB’s products.
An Advansys perspective on Wonderware Intelligence
Wonderware Intelligence is essentially a data warehousing solution for manufacturing. For example, simply stating that the OEE (Overall Equipment Effectiveness) is currently 92% (a Measure), isn’t particularly informative. However, stating that team 2 achieved 92% OEE for the morning shift on packaging line 1 while producing Castle Lager is true information because it’s put the measure in the context of teams, time, equipment and product (all of which are known as Dimensions).
Wonderware Intelligence operates at two levels:
- Data collection and organisation into measures and dimensions. Data can be collected in near-real-time from a multitude of disparate data sources and linked by time and time ranges.
- The visualisation of information through dashboards (Dashboarding). “A dashboard is a visual display of the most important information needed to achieve one or more objectives; consolidated and arranged on a single screen so the information can be monitored at a glance” Stephen Few, 2006. They provide everyone with the same version of the truth and increase the speed of decision-making.