Easy to Build Reports from Automation Data

Easy to Build Reports from Automation Data

Data are worthless without the ability to put it into a context and present it in a simple way to decision makers—no matter where in the company they reside. Enter Ocean Data Systems (ODS) and its product Dream Report.

Note: Dream Report obviously is an advertiser on this blog. However, I’m not a trade magazine, so writing about advertisers isn’t mandatory. I’ve known the Marketing VP for almost 20 years, and he has always represented quality products. I pass this along not as a reviewer but because I think it’s useful.

Ocean Data Systems (ODS) announced that Dream Report version 4.82 is posted and available for download. Along with a broad array of Customer Software Change Requests (SCRs), this release delivers on a theme of Partner Connectivity. Dream Report is now the official solution for the Aveva – ClearSCADA solution and version 4.82 includes drivers to access historical values, historical messages and real-time values. This release also includes new connectivity for the OSIsoft – PI Historian and Asset Framework. Enhanced connectivity is also delivered for the Aveva – Wonderware Online InSight product and the Dream Report – Advanced ODBC Driver for time series data in SQL Databases.

General features and benefits improvements include an enhanced Automatic Statistic Table to add flexibility for ad-hoc analysis, new access to Table Footer data delivering the ability to enhance report calculations using table footer results and support for .xlsm (Excel File Format) to support macros.

“Each new ‘Purpose Built’ Driver added to Dream Report enables Dream Report to ideally support a new market segment and lets those customers benefit from Dream Report – Compliance Reports, Performance Dashboards and Ad-hoc Analysis,” explained Roy Kok, VP Sales and Marketing for Ocean Data Systems. “We always include enhancements that benefit our entire installed base and this release is no different. The Dream Report release notes, in the documentation directory, will detail all changes.”

Founded in 2004, Ocean Data Systems develops software solutions for industrial compliance and performance; reports, dashboards, and ad-hoc analysis and troubleshooting. Dream Report delivers both local and Internet connectivity to all major HMI/SCADA, Historian and business data sources through either proprietary or industry standard drivers. Dream Report’s markets include process, hybrid and discrete; with special functionality for Life Sciences (Pharmaceutical and Biotech), Water, Wastewater, Heat Treat, Building Automation, Energy Management and Manufacturing Operations.

These are the main features of Dream Report:

1- DATA COLLECTION
Dream Report integrates a robust communication kernel to collect data and alarms from multiple real time and historian sources. It uses OPC, OLE, and ODBC standards to connect and collect Data from different suppliers. Moreover, ODS develops custom drivers to leverage native history from SCADA systems, DCS, RTU and more….

2- DATA LOGGING
Dream Report integrates a powerful historian module to log clean and accurate data in any standard database such as SQL Server, Oracle, MySQL, Access…
This unique feature position Dream Report not only as a reporting tool, but also as the ideal solution of field Data integration for enterprise applications.

3- DATA EXTRACTION & ANALYSIS
Dream Report integrates a user friendly object library to extract Data statistics and analysis to be displayed in multiple views like tables, Bars, Pies, Charts and more…

4- REPORT DESIGN
Dream Report’s studio integrates an intuitive graphical editor to create and save state of the art reports as templates.

5- REPORT GENERATION & DISTRIBUTION
Dream Report enables to generate reports manually and automatically. The automatic mode enables to execute report on event and on schedule. When ready, reports can be automatically printed, emailed, stored and published over the web.

Without Analytics The IIoT Is Meaningless

Without Analytics The IIoT Is Meaningless

Connecting your plant devices through the Industrial Internet of Things (IIoT) generates lots of data; but, without powerful analytics and visualization, it’s all meaningless.

Therefore, Plex today announced a new analytics product.

The IntelliPlex Production Analytic Application, available now, taps IIoT data to provide manufacturing leaders with enterprise-wide insight into the performance of production operations, including processes and equipment on the shop floor.

This application adds to Plex’s IntelliPlex Analytic Application Suite, which includes applications for sales, order management, finance and procurement. This suite, with the addition of production analytics, delivers to manufacturers the industry’s most comprehensive cloud analytics, uniquely providing visibility all the way down to the shop floor.

The Plex Manufacturing Cloud is a comprehensive platform for manufacturing enterprises, connecting suppliers, customers, people, equipment, materials and finances across multiple facilities to form the technology backbone of an organization. Plex uses real-time IIoT connections as a core mechanism for managing manufacturing operations and enterprise resource planning.

That comprehensive view means Plex not only streamlines and automates operations, but also enables unprecedented access to companywide information including IIoT data. The IntelliPlex suite of analytic applications turns that data into configurable, role-based, decision support dashboards – with deep drill-down and drill-across capabilities. Plex first introduced the IntelliPlex Analytic Application Suite in 2016 with turnkey analytics for sales, order management, procurement and finance professionals.

  • The IntelliPlex Production Analytic Application provides insight into key performance measures such as overall equipment effectiveness (OEE), scrap rates, first pass yield, inventory turns, on-time jobs and machine availability.
  • IntelliPlex is configurable, so users can create custom performance dashboards and combine metrics to form their own analysis based on the wealth of data stored in the Plex Manufacturing Cloud.
  • IntelliPlex analytics are also drillable, enabling users to instantly go from top-line performance analysis directly into data and details across plants, time and geographies.
  • IntelliPlex applications are easy to activate as part of the Plex Manufacturing Cloud, and can be quickly extended and configured to match an organization’s evolving needs over time.
  • The Production Analytic Application is available now.

Plex is planning to deliver additional analytic applications, including supply chain and human capital management. All applications are accessible to customers without the need for a lengthy implementation process.

“At Plex, we know that the best manufacturing organizations are built on the shop floor and that operational excellence is the foundation of product quality, company growth, and profitability,” said Karl Ederle, group vice president of products for Plex. “The IntelliPlex Production Analytic Application is unique because it provides an enterprise-wide view of manufacturing performance, combined with the ability to tap into the IIoT signals from equipment on a specific production line. Plex now offers customers analysis of their organization that truly spans from shop floor equipment to the financial bottom line.”

“This is not an IT tool, it’s an empowerment tool,” said Janice D’Amico, Plex specialist lead, Hatch Stamping. “The IntelliPlex Production Analytic Application has given Hatch access to accurate, near real-time data cross-enterprise that is user-friendly – easy to create, understand and share. We see this application being used at all levels of the organization to make better business decisions. The opportunities are endless.”

“In many manufacturing organizations, there is a communication breakdown between the front office and the shop floor,” said Alexi Antonio, Plex Analytics product lead. “Because the three OEE production metrics—performance, quality, and availability—are not expressed in monetary units, daily efforts to improve processes using OEE alone do not always translate into bottom-line savings. Plex puts OEE and financial metrics into a single dashboard, for the first time giving manufacturing leaders the ability to see and manage complete business performance.”

Improve Manufacturing Operations With EMI Applications

Improve Manufacturing Operations With EMI Applications

Mark DavidsonOne of my prognostications from my last post on 2015 prognostications riffing off Jim Pinto’s post, dealt with analytics. I think this will not only be big, it will be essential to making you and your manufacturing enterprise competitive.

Mark Davidson of LNS Research, just wrote about the subject, Enterprise Manufacturing Intelligence (EMI) software, on the LNS blog site.

He asks, “1) What are the business results that manufacturing/production companies are achieving utilizing these software capabilities? And 2) What should you and your company be doing in regard to the opportunities presented by these technologies?”

He correctly addresses the core capability—operational and business performance dashboards that provide timely information to different users and roles.

Are people using these now? “61% of companies in the LNS Research Manufacturing Operations Management (MOM) survey of over 550 professionals indicated that their companies either currently have EMI dashboards or are planning to install them in the next year.”

Here’s why this is important. “The joint LNS Research and MESA ‘Metrics That Matter’ survey uncovered a significant difference in average annual improvements in the costs of producing a unit of goods. Current users of EMI software recorded 24.1% average annual improvements in Total Cost per Unit Excluding Materials versus the 13.1% overall improvement of all respondents.” And, “Companies that have implemented EMI software solutions are experiencing 7.2% higher OEE performance than those who have not. The average OEE for those who have EMI solutions in place was 74, versus 69 for those who do not.”

Make sure your stars are aligned

And, his last thought, “It is imperative that you not only focus on these supporting new technologies, it’s important to also align your organization’s key resources: people and processes, along with your technology strategy.”

Check out Mark’s complete article. Then check out potential partners for implementing EMI applications. Let me know how you’re doing.