Business intelligence solution presents customer data without delay

The accounts receivable (A/R) department at Virtek Vision International had its hands full. Credit managers at the Ontario-based supplier of laser marking products needed to keep collections up-to-date by identifying those potentially delinquent before they became problems. Until recently, workers relied on spreadsheets that pulled information from the company's ERP system.


The accounts receivable (A/R) department at Virtek Vision International had its hands full. Credit managers at the Ontario-based supplier of laser marking products needed to keep collections up-to-date by identifying those potentially delinquent before they became problems.

Until recently, workers relied on spreadsheets that pulled information from the company's ERP system. The process was slow, cumbersome, and inflexible.

“We couldn't identify key accounts on one screen, and we didn't have access to certain data,” says Katherine Campbell, corporate controller. “In our ERP system, customer information is in one massive table and the data is located by field, but not labeled. It used to take credit managers an entire day to run the collections report, which was then emailed to those needing it.”

This process is much more efficient since the company deployed a business intelligence (BI) solution from a German company known as AXLE Studio . Using AXLE Studio 2007, credit managers get automatic warnings when an account becomes 45 days past due. The system also identifies which companies should be given restrictions on future orders.

Reports are generated and sent on-demand via email to unit managers.

“Our IT staff is working on getting the reports to run daily automatically,” says Campbell. “We want to enable users to create their own customized reports specific to their product lines. Managers should be able to see their receivables, backlog, and revenue.”

The AXLE system is part of a four-phase implementation process that began last year. It runs on an SQL Server database that also partially supports the BI functionality in Virtek's ERP system. In the future, the company plans to extend the system to include more users; and offer new functionality, including volume of order shipping, global cash reporting, and multiple currencies.

Right now, Virtek is working with Dynac , an Ontario-based value-added reseller for AXLE Studio, to build an extraction layer in the system that creates triggers to pull knowledge from disparate systems and display it in a meaningful way.

“Users can see how many new orders were booked today or how many were changed,” says Gary MacFarlane, Dynac CEO and cofounder. “Instead of having to look up the data in five or six places, the system gives it to them on one screen.”

Since the system is Intranet-based, it does not require any additional hardware or servers. It uses a fat client and is housed within the corporate structure.

Unlike most BI systems, AXLE Studio does not require building a data warehouse, so it's deployed more quickly.

“Data can be refreshed automatically, and query loading can be done at off-peak hours,” says MacFarlane. “Data warehouses typically are refreshed periodically, and often users must wait for current data to be uploaded.”

Laser marking systems specialist Virtek Vision International recently completed a four-phase deployment of an AXLE Studio business intelligence (BI) system. Now BI functionality is supported in Virtek’s ERP system, and cumbersome spreadsheets and reporting processes are part of the past.

Meant for small to midsize businesses, or divisions of larger companies, “The system does not have functionality like regression analysis or extensive statistical analysis tools common to large BI systems,” says MacFarlane. “However, it connects to key data sources such as general ledgers and ERP systems, and links to multiple database tables, and across multiple databases.”

AXLE Studio users can learn to become designers, building their own queries and cubes.

“There's no need for special licenses or extra modules, and users easily can turn functions on and off,” says MacFarlane. “They don't have to build extension modules, as is often required with traditional BI solutions.”

There are nearly 6,000 users of AXLE Studio worldwide, and the company only recently entered the North American market. Dynac represents AXLE in the Americas, offering installation, technical support, and user training.

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.
Each year, a panel of Control Engineering and Plant Engineering editors and industry expert judges select the System Integrator of the Year Award winners in three categories.
Pipe fabrication and IIoT; 2017 Product of the Year finalists
The future of electrical safety; Four keys to RPM success; Picking the right weld fume option
A new approach to the Skills Gap; Community colleges may hold the key for manufacturing; 2017 Engineering Leaders Under 40
Control room technology innovation; Practical approaches to corrosion protection; Pipeline regulator revises quality programs
The cloud, mobility, and remote operations; SCADA and contextual mobility; Custom UPS empowering a secure pipeline
Infrastructure for natural gas expansion; Artificial lift methods; Disruptive technology and fugitive gas emissions
Power system design for high-performance buildings; mitigating arc flash hazards
VFDs improving motion control applications; Powering automation and IIoT wirelessly; Connecting the dots
Natural gas engines; New applications for fuel cells; Large engines become more efficient; Extending boiler life

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.
The maintenance journey has been a long, slow trek for most manufacturers and has gone from preventive maintenance to predictive maintenance.
This digital report explains how plant engineers and subject matter experts (SME) need support for time series data and its many challenges.
This digital report will explore several aspects of how IIoT will transform manufacturing in the coming years.
Maintenance Manager; California Oils Corp.
Associate, Electrical Engineering; Wood Harbinger
Control Systems Engineer; Robert Bosch Corp.
This course focuses on climate analysis, appropriateness of cooling system selection, and combining cooling systems.
This course will help identify and reveal electrical hazards and identify the solutions to implementing and maintaining a safe work environment.
This course explains how maintaining power and communication systems through emergency power-generation systems is critical.
click me