1 / 104

Getting the Most Out of Wonderware Historian 2012 and Reporting Options

Getting the Most Out of Wonderware Historian 2012 and Reporting Options. Elliott Middleton PBWW321 November 10, 2011. Invensys Enterprise Control Offerings. Corporate Systems. Industry Solutions Services: Consulting, Project Execution, Learning,

diep
Download Presentation

Getting the Most Out of Wonderware Historian 2012 and Reporting Options

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Getting the Most Out of Wonderware Historian 2012 and Reporting Options Elliott Middleton PBWW321 November 10, 2011

  2. Invensys Enterprise Control Offerings Corporate Systems Industry Solutions Services: Consulting, Project Execution, Learning, Operational Improvement, Maintenance & Support Partner Ecosystem Corporate Software Applications Invensys and Third Party Manufacturing / Production Operations Automation Invensys and Third Party Enterprise Control System IT Platform Integration and Collaboration Platform

  3. Where The Offerings We Will Discuss Fit Within TheInFusion Enterprise Control System Execution Integration & Collaboration Platform Enterprise Asset Management Mobile Workforce Management Manufacturing Execution Systems Batch Performance Software Applications Enterprise Manufacturing Intelligence Performance Measurement and Reporting Asset Performance Enterprise Integration Visualization Quality Optimization Workflow Advanced Process Control Simulation / Optimization Design Operator Training Third-Party Offerings Open Device Integration Web Portal Control Automation Software Applications DCS PAC SCADA HMI Application Toolkit Safety Turbomachinery Control Safety Instrumented Systems General Purpose Safety Historian Measurement & Instrumentation Recorders Instrumentation Controllers

  4. Historian 10.0 • Technology Update • Better solutions for geo-SCADA • Improved namespace integration • Broader usage of data Assuming familiarity with Historian 9.0

  5. Historian 10.0 • Technology Update • Better solutions for geo-SCADA • Improved namespace integration • Broader usage of data

  6. Historian Technology Support No cluster support planned

  7. SQL Server 2008 Considerations • Install • Must select 32-bit when using 64-bit OS • When using SQL Server 2008, requires SP1 • Be deliberate with “Provisioning” (sysadmin) • Clients • Require “SQL Server Native Client” for 2008 (SQLNCLI10) • Included on the SQL Server CD • Without it: ”Invalid attempt to GetBytes on column 'DateTime'” • Exposes 1 millisecond resolution (2005 still 3.3 millisecond) • No support for SQLXML 3 used by ActiveFactory/WIS • Editions: Express, Standard, Enterprise (default instance)

  8. Historian 10.0 • Technology Update • Better solutions for geo-SCADA • Improved namespace integration • Broader usage of data

  9. Tiered Historians Tier-2Centralized reporting & system of record Tier-1Local troubleshooting & buffering Application Server I/O InTouch

  10. Tiered Historians: All Data (“Simple”) Tier 2 Example: 1-second data Replicate all data for selected or all tags Tier 1 Example: 1-second data

  11. Tiered Historians: Summary Data Tier 2 Example: 5-minute, hourly, daily data ∑ “Summary” Tag Many aggregate values for each Tier 1 Example: 1-second data

  12. Summary Tag Aggregates • Analog • Time-weighted average, standard deviation & variance • Integral • First/last value in period with timestamp • Min/max value in period with timestamp • Seconds of “good” values • State (for each state) • Number of occurrences (partial & contained) • Shortest/longest/average occurrence (partial & contained) • Total/percent occurrence (partial & contained) Each summary tag has all aggregates

  13. Local Summary Replication Alternative to existing Summary System

  14. Multiple Tier-2 Historians New Orleans Houston

  15. Network Isolation & Tiered Historians Tier-2: Corporate Network Single port from control network No open ports from corporate network Tier-1: Control Network Application Server I/O InTouch

  16. Robust Tiered Historians • Store-forward between tiers • Spread load across period when possible • Propagate From Tier 1 • Store-forward events • Inserts/Updates • “Late” Data • No tag count increase (150,000)

  17. Preconfigured Added “Tier 1” System

  18. “Tier 2” System “Pushed” from Tier 1

  19. Historian 9.0 Architecture Active Factory Microsoft SQL Server Core Storage System I/O History Blocks

  20. Historian 10.0 Architecture Historian Client Microsoft SQL Server “Tier 1” Engine “Tier 2” Engine From Tier 1 I/O

  21. New Historian Services “Tier 2” Storage/ Retrieval Engine “Tier 1” Replication Service New WCF-based API

  22. Replication Architecture Tier 2 • “Live” data uses running accumulators • “Old” data uses Retrieval-based Synchronization “Tier 1” Engine “Tier 2” Engine I/O Single TCP port MDAS Service Tier 1 Replication Service “Tier 1” Engine Three Channels • Streaming data I/O • Buffered data (late/SF)* • Updates/inserts* * Go to “synch queue”

  23. Replication Security Tier 2 “Foo” in “aaReplicationUsers” Group “Tier 1” Engine I/O Replication Server User “Foo” I/O Tier 1

  24. Monitoring Replication On Tier 2 “0” can be a permission problem On Tier 1

  25. Schedules & Groups “Tier 1” System Replication Schedules • Defines periods • Abbreviation for schedule Replication Groups • Selects a schedule • Abbreviation for group • Default naming scheme

  26. Manually create groups to use a schedule • Can be added automatically to new servers

  27. Replication & “Odd” Periods • Always based on local Tier 1 time • Always anchored at midnight Period = 5 hours 4 hours

  28. Replication & Daylight Savings Time • Always based on local Tier 1 time • Period: Fixed frequency • Custom: Fixed time-of-day “Fall Back” Custom: 0, 4, 8, 12, 16, 20 “Fall Back” Period = 4 hours “Fall Back” Period = 30 min 4 hours 5 hours 1 hour

  29. Replication & Daylight Savings Time • Always based on local Tier 1 time • Period: Fixed frequency • Custom: Fixed time-of-day “Spring Forward” Custom: 0, 4, 8, 12, 16, 20 “Spring Forward” Period = 4 hours “Spring Forward” Period = 30 min 4 hours 3 hours 3 hours

  30. Question If a single summary tag contains multiple aggregates values, how do you access each in a query?

  31. Summary Retrieval • Existing 9.0 “Extension Tables” • History • WideHistory • StateWideHistory • New 10.0 “Extension Tables” • AnalogSummaryHistory • StateSummaryHistory • Use all with conventional & summary tags

  32. AnalogSummaryHistory

  33. Comparing “BestFit” Retrieval Source Tag 1 minute Summary 1 Hour

  34. Retrieving Summary Data • Query Resolution Examples: 1-minute Summary • 1-minute: returns stored values • 1-hour: summarizes 60 1-minute values • 30-second: divides 1-minute values • Cycle Boundary Alignment • Uses stored values when aligned • Prorates stored values otherwise

  35. StateSummaryHistory

  36. Historian 10.0 • Technology Update • Better solutions for geo-SCADA • Improved namespace integration • Broader usage of data

  37. Names In Application Server Hierarchical Name Object Tagname Contained Name Attribute Reference

  38. Application Server Namespace Historian Client ArchestrA IDE

  39. Hierarchical Names In Historian Client 10.0 • Supported In • Trend • Query • Workbook (Excel) • Report (Word) • Controls • In Trend Impacts • All Tag Labels • Tag Picker TagName/Hierarchical Name Toggle

  40. Both accept wildcards Both return single-column, table results New Database Functions dbo.faaGetHierarchicalAttributeNames(TagName) dbo.faaGetHistorianTagNames(HierachicalAttributeName)

  41. Historian 10.0 • Technology Update • Better solutions for geo-SCADA • Improved namespace integration • Broader usage of data

  42. Broader Usage Of Data • "Cleansing" • More important further from process • Instrument error can accumulate • Expanded Industrial Aggregation • More "time-in-state" aggregates • Floating point "counter"

  43. Integer Counter 9.0 Review Cyclic Looks like constant rate

  44. Counter Retrieval Full Counter • 9.0: Integer analog tags only • 10.0: Add real analog tags (flow meters)

  45. Integral vs. Average 9.0 Review Full liters/min Integral liters Average liters/min Now what’s the difference? Scale When is it important? Reporting

  46. Reporting Support: Industrial Data Cleansing Spikes “Gaps” or “bad” data quality

  47. Removing Outliers • Supported for all modes • Most useful for aggregate modes • Average • Integral

  48. Example: Removing Outliers

  49. Filter Outliers (“SigmaLimit”) SELECT DateTime,vValue,StateTime,wwFilter FROM History WHERE TagName IN('Reactor1Level') ANDDateTime>='2010-07-04 15:00:00' ANDDateTime<='2010-07-04 17:00:00' AND wwRetrievalMode ='avg' AND wwFilter = 'SigmaLimit(2)'

More Related