220 likes | 339 Views
AF2 There is a lot you can do today. Frank Batke Ray Hall. concern and content. Wrap up an Overview of today's features Adding Structure Accessing non time series sources Why AF 2 ? Architecture of AF 2 Best Practice AF1 + AF2 AF2 Security Demo. The Server. The Analytics.
E N D
AF2There is a lot you can do today Frank Batke Ray Hall
concern and content Wrap up an Overview of today's features Adding Structure Accessing non time series sources • Why AF 2 ? • Architecture of AF 2 • Best Practice AF1 + AF2 • AF2 Security • Demo
The Server The Analytics The Visuals Smart Clients PI ProcessBook ACE PI Archive PI DataLink PI Analytics PI AF PI Activeview RtReports Real-Time Interfaces PI BatchView PI Notifications Data Access Thin Clients Sigmafine MCN Health Monitor RtWebParts RtPortaliViews RtReports Clients
The Server PI Archive PI AF Real-Time Interfaces Data Access MCN Health Monitor
PI AF 2.0 in the PI System • Data structured and organized by asset • Spans multiple PI Systems • Incorporates non time series data PI Server 1 PI Server 2 PI AF 2.0 Vendor Specific Interfaces Generic Interfaces Vendor Specific Interfaces Generic Interfaces Asset-Equipment Centric access to the Data Honeywell Interface ABB Interface Delta-V Interface Rockwell Interface OPC Interface XML Interface Modbus Interface SNMP Interface Honeywell Interface ABB Interface Delta-V Interface Rockwell Interface OPC Interface XML Interface Modbus Interface SNMP Interface Time Series Data Sources … Honeywell ABB Delta-V Rockwell Other Non Time Series Data Sources Time Series Data Sources … … Honeywell ABB Delta-V Rockwell Other RDBMS MES SCM
Evolution ACEModule relative Displays Notifications ProcessbookDatalinkBatchPerformance Equations Control Monitor Asset Element Module “foreign” structures Unification Tag Connections Templating Flow sheeting “foreign” data Model analyses Context Aliasing VersionsHierarchies History Connectivity Analysis Framework 2.x Analysis Framework 1.x Module database PI – Archive
AF vocabulary (*) AF 1.x explorer
Architecture AF Client 2x PI System Explorer SQL server AF2 server PISERVER Time series Data PI 3.4x PI Notifications AF Compabilitylayer 1.x to 2.x AF Client 1.xAF Explorer MS Office Processbook AF-Addin Excel AF-Addin
Architecture AF Explorer AF Modeler • Check-In, Check-out functions • Queries • Object Retrieval • Paging • Changes since specified time • Object to Object propagation AF-SDK OLEDB Data References NT Service Host • Audit Trail Generation Service Operations • Referential Integrity • Cascade Deletes • Field Constraints SQL Server Stored Procedures Triggers Constraints Tables • Basic Storage • Checked-Out Objects (sandbox) • Audit Trail
Features • Object History (versioning) • Keeps track of configuration changes over time • Hierarchical Attributes and Categories • Advanced Attributes Types • Files, Arrays, Tables • Enumeration Sets • Object Level Security • Windows Integrated Security
AF and context 88.5 88.5 Analysis brought into context becomes reusable and allows single point of maintenance
Putting AF into Best Practice Shaping your data by: • Condensor • Heatexchanger • Column • Valve • Pipe • Pump • 1. Defining types of assets Templates Schema how to attribute Elements • 2. Association to a “real” asset Elements • Created from Template • 3. Describing the “real” asset Attributes • having Units Of Measurements (UOM) • can come via data references from everywhere • 4. Physical/logical asset structure Hierarchy • 5. Assets connectivity Models • Model : Collections of connected elements • Column661 • Condensor661 • P661_1 • P661_2 • HeatExchanger661 • Valve661_1 • Valve661_2 OpeningGrade PI Point: \\MOBILEVBC\Valve661_1.OpeningGrade InspectionResult Table Lookup: SELECT InspectionResult FROM … LastInspection Table Lookup:SELECT LastInspection FROM … SerialNumber Table Lookup: SELECT SerialNumber FROM … XZY Formula: A=OpeningGrade;[A*0.98]
Developed Once – Deployed Everywhere Assets Template Process Data / Events Hierarchy ELEMENT ELEMENT Connectivity Role based ELEMENT Other Data TIMESERIES DATA SOURCES ELEMENT TAG ATTRIBUTE WITH UOMi.e. FlowRate l/h Datareference TIMESERIES DATA SOURCES TAG ATTRIBUTE WITH UOM Datareference • Collections of reusable Elements ATTRIBUTE WITH UOMi.e. LastCalibration NON TIMESERIES DATA SOURCES Datareference UOM Units of Measurement
Scope: Exposing „non-PI“ Data Column Condensor Heatexchanger ShellFlow 755.43 l/h TubeFlow 485.45 l/h OvHeatTraCo 2576 W/(m² K) Temp.Max RDBMS Data Reference to External Value Press.Max MaintenanceEvent #2 MaintenanceEvent #1 MaintenanceEvent #N Maintenance System … Association to Records Technician Technician Technician Comments Comments Comments
Categories Money Costs Earnings Business KPI Finance Executive Stock Value Availability Performance Security IT Accounting HealthGovernmentRegulation ProcessEngineering Environment Product Empirics Stock Capacity Deliveries Price Purchase R & D Innovation Empirics Maintenance Quality Limits Consistency Availability Performance Security ProcessOperation Automation Reproducibility Throughput Yield Waste
PI UFL Interface + POP3 addin FILE/MAIL – Server RELATIONAL DBs Use case – master of configuration Internet - explorer User PCDashboardsReportsExcel via Excelservices Processbook Datalink (excel) Power User Publish Dashboards and reports WebPartPage content PI Server +MDB ( structure mirror filled using MDBBuilder) +ACE RT-WebParts MOSS DLES PI – Data Direct and via OLEDB +AF2 (Datamaster for versionising, exportable via excel) +PINOTIFICATIONS RTBaseline Other datasource PI - Data Mailing
Use case – „batch“ notifications PI- ACE Calculation and Recalculation i.e. detect violations PI Notification AFElement (Reactor) “Violation” –attribute “Process” –attributes “Limit”- attributes “Batch” –attributes Trigger MDB2AF, MDBbuilder Afexcel ,Other tool Sync / copy /export ModuleDatabase Module (Reactor) “Violation” – alias “Process” – alias “Limit”- alias “Batch Control” – alias Add. Information Table Data Reference PI Point Data Reference PI Batch Generator “Batch” View Via PI Oledb PI Batchdatabase PI “Tag Archive ” historizes PI Interface (UFL /OPC etc.) Process data sources
Demo Architecture – Active Directory AF Client 2x PI System Explorer SQL server PI Server Time series Data PI 3.4x AF server 2.X PI DesktopAlert SMTP server PI Notification scheduler PI Processbook Notification viewer addin IIS MS Office AF Compabilitylayer 1.x to 2.x MyPI AF Client 1.xAF Explorer Excel DL 4.0-Addin Processbook AF-Addin Excel AF-Addin
Demo • Windows 2008 server + DC functionality • mailserver • office • PI 3.4.375.80 • AF 2 • MSSQL 2008 Express • DL 4.0 • PB 3.1 • On Vmware server with 1.5 GB Memory We are resource friendly
Summary • AF is ready to use • what you invest in structuring is save • don’t do conceptual work not taking in account AF • AF is not isolated AF-excel addin and MDB builder is the first “glue” • Notification is one of the first usecases • AF future is bright