mike brost simple tasks historian - wonderware california · 2018-05-23 · world’s easiest to...

Wonderware Historian

Simple Things You Can Do with Historian

Confidential Property of Wonderware California Page 1

Presented by Mike Brost

Confidential Property of Wonderware California Page 7

Wonderware Historian Helps… Consistently capture accurate, real-time information automatically

Visualize & Analyze Plant Performance Easy Access to Real-Time and Historical Trends & Reports

Use Cases Process & Product Quality Optimization Quickly Troubleshoot Alarms & Process Upsets Production & Efficiency Reports Regulatory Compliance Reports Energy Reports

Lower Costs and Increase Efficiency, Reliability

World’s Easiest to Use Plant Historian Industry Leading Ease of Use – No SQL knowledge required!

o Fully Integrated – automatically creates Historian tags and built‐in store & forward redundancyo Automatically manages storage based on size/age/remaining disk spaceo Redundant Historians provide retrieval redundancy – configure in minutes

Storage & Retrieval Built for Real‐Time Industrial Operationso 1/50 of the storage space compared to traditional SQLo Retrieve a 1 Year Trend in seconds!o Store at the Resolution of Your Process (ie. down to the second for troubleshooting)o Advanced Retrieval Modes for Reporting (ie. 15min, Hourly, Daily, Min/Max/Avg, Total Flow, Uptime/Downtime)

Industry Leading Data Analysis & Reporting Toolso Powerful and User Friendly Trends & Dashboardso Excel Add‐In – Easy Access to Your Data FASTo Automated Reports (ie. Daily, Weekly, Monthly, Batch Based)o “Point & Click” Queries – automatically builds custom SQL, no programming required

8

Historian Architecture

DataSources

Wonderware Historian

Reporting & Analysis

Real Time & Historical Trends

Secure Accesson Your Business

Network

Access Data fromAnywhere

Tier-2 EnterpriseHistorian

&Wonderware Online

Enterprise Historian: Share Plant Data Securely with Corporate Users

Corporate Network

Enterprise “Tier 2” Historian

Business DomainHistorian

Client

Application ServerInTouchI/O

Control Network

“Tier 1” HistorianSCADA Domain

HistorianClient

Historian Client

Open OutboundReplication (single TCPport)

Confidential Property of Wonderware California Page 13

InTouchInTouch Machine Edition (ME) OPC, JSON, ExcelHistorian Tier-1

Connect to your existing datasources

City Saved $200k+ Year with Increased Billing Accuracy

Page 7Confidential Property of Wonderware California

Were previously direct billed by Regional Sanitation District. Historical Trends for Sewer Flow Daily/Monthly Totals are now used for billing because the city’s flow meters are calibrated regularly. Discrepancies were found averaging 2-3 MGD, saving the an average of 18,000 a month

Troubleshooting I/I in Sewer Lines

Page 8Confidential Property of Wonderware California

On the sewer system during a rain event sewer flow stations would go from the normal flow 4-6 MGD to 15 MGD. Using Historical trends and flows, Operators were able to isolate areas where there was an increase in infiltration in the line versus just an increase in sewer effluent.

Well Improvements

Page 9Confidential Property of Wonderware California

Operators use summary tags to see what wells have been producing, measure flow, pump performance and ground water levels. They are able to diagnose if it’s an aquifer or pump issue. Trends help determine where maintenance is needed visually.

10Confidential Property of Wonderware NorCalNovember 2015 May 2016

Increasing Yield 5% by Reducing Product Give AwayImproved Line Efficiency and reduced Give-Away within 6 months

11Confidential Property of Wonderware NorCal

Sample Weight Tracking• Operator takes periodic sample weights which are

recorded/displayed in a trend to verify if they are within specifications

Confidential Property of Wonderware California Page 17

Brewery Water Usage & Wastewater DischargeReports

Confidential Property of Wonderware California Page 17

Packaging Line Performance Report

▲ Introduced in Historian 10.0 (2012)▲ Ad Hoc on any Tag▲ Pre-calculated, Periodic Time Periods

▲ What’s Good▲ Over 200x faster than ad hoc▲ Transparently re-summarize

▲ Not So Good▲ Required Extra Configutation▲ Must intentionally select a different tagname

▲ Solution: Make them transparent (“auto-summary”)

About Summary Tags

Page 15Confidential Property of Wonderware California

Auto Summary Timeline

Confidential Property of Wonderware CaliforniaPage 16

Replication Backfill

▲ Run aahBackfillUI.exe

Confidential Property of Wonderware CaliforniaPage 17

Historian Rights Requirements

Confidential Property of Wonderware CaliforniaPage 18

No elevated Windows or SQL ServerRights required post-install

Historian Data Types

Confidential Property of Wonderware CaliforniaPage 19

Why Block-based Alarm & Event History?

Confidential Property of Wonderware CaliforniaPage 20

Historian Time Series Data

Confidential Property of Wonderware CaliforniaPage 21

Structured Event Storage in Historian

▲ Basis of current Alarm and Events in History Blocks▲ Customized Structured Data Records are Supported

▲ JSON Pair (Name, Value)▲ 50 Pairs per Record▲ Each Value up to 320 Characters (Text)▲ Multiple Data Types Supported

▲ Blob, Boolean, Byte▲ Date, DateTime, Duration, TIme▲ Float , Decimal, Double▲ GUID, Hex, Int, Interger, Long, Short, String▲ UnsignedByte, UnsignedLong, UnsignedShort, UnsignedInt

© 2018 AVEVA Solutions Limited and its subsidiaries. All rights reserved.

Structured Event Storage in Historian

▲ Stored in On-Premise or Cloud Historian▲ Uses Historian SDK to Generate Event Record

▲ HistorianEvent myEvent = new HistorianEvent();myEvent.EventTime = DateTime.Now;myEvent.ID = Guid.NewGuid();myEvent.Type = “WOExecution";

▲ myEvent.AddProperty(“WOID", “WO-745812”, error))myEvent.AddProperty(“ProductID", “Cherry Soda”, error))myEvent.AddProperty(“Quantity", i.ToString(), out error))// ... set other properties here

▲ historian.AddStreamedValue(myEvent, error))

© 2018 AVEVA Solutions Limited and its subsidiaries. All rights reserved.

Event Retrieval from Historian

▲ Historian SDK▲ EventQueryArgs eventQueryArgs = new EventQueryArgs();

eventQueryArgs.EventOrder = HistorianEventOrder.Ascending; eventQueryArgs.StartDateTime = new DateTime(2014, 9, 1, 0, 0, 0); eventQueryArgs.EndDateTime = new DateTime(2014, 9, 30, 0, 0, 0); eventQueryArgs.EventCount = 1000;

▲ EventQuery eventQuery = historian.CreateEventQuery();▲ eventQuery.StartQuery(eventQueryArgs, error)▲ eventQuery.QueryResult.EventTime

eventQuery.QueryResult.WOIDEventQuery.QueryResult.ProductID

© 2018 AVEVA Solutions Limited and its subsidiaries. All rights reserved.

Event Retrieval from Historian

▲ OData/REST API▲ Submit requests using a web browser▲ Microsoft Excel (2013, 2016, or Office 365)▲ Business Intelligence (BI) systems, such as Tableau and Microsoft Power BI

▲ http://localhost:32569/Historian/v2/Events?$filter=EventTime+gt+'2017-07-13T00:00:00'

▲ http://localhost:32569/Historian/v2/Events?$filter=type+eq+’WOExecution'

© 2018 AVEVA Solutions Limited and its subsidiaries. All rights reserved.

26

sales@california.wonderware.comQuestions? We Can Help!