techniques for optimizing asset analytics · asset analytics overview. #piworld ©2019 osisoft, llc...
TRANSCRIPT
![Page 1: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/1.jpg)
#PIWorld ©2019 OSIsoft, LLC
Techniques for Optimizing Asset Analytics
Presented by: Nathaniel Adebayo
1
![Page 2: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/2.jpg)
#PIWorld ©2019 OSIsoft, LLC 2
Agenda
•Asset Analytics Overview
•Best Practices• Building expressions
• Using Event Frames to capture critical events
• Backfilling and Recalculations
• Management
•Summary
![Page 3: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/3.jpg)
#PIWorld ©2019 OSIsoft, LLC#PIWorld ©2019 OSIsoft, LLC 3
Asset Analytics Overview
![Page 4: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/4.jpg)
#PIWorld ©2019 OSIsoft, LLC 4
Asset Analytics
• 150+ built in functions
• Streaming calculations triggered by events or clock
• Output to PI Points for reporting and trending
• Create event frames and rollups
• Trigger notifications
• Supports templates, fully integrated into PI AF
• Backfill and Manual recalculation
• Auto-recalculation for late or out-of-order data
![Page 5: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/5.jpg)
#PIWorld ©2019 OSIsoft, LLC
Workflow
Configure Test
Backfill/Recalculate
ScheduleSchedule
![Page 6: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/6.jpg)
#PIWorld ©2019 OSIsoft, LLC 6
A bit about Context…
Typical use case:
I want to monitor and detect problems with my compressor, before they become catastrophic.
• AF models assets and processes
• Inputs (typically) come from the asset
• Analysis outputs are mapped on the asset
![Page 7: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/7.jpg)
#PIWorld ©2019 OSIsoft, LLC 7
A bit about Context…
Typical use case:
I want to aggregate EV and Solar production for my substations.
• Inputs come from asset hierarchy
• Analysis outputs used in dashboards, CBM, KPIs & reports
![Page 8: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/8.jpg)
#PIWorld ©2019 OSIsoft, LLC
PI Analysis Service
8
PI Analysis Service - Overview
AF
Server
PI Data
Archive
Calculation Engine
Data
Cache
A
B
…
2
Read from
data cache3
Analysis
Load analysis
configuration1
Read from
data source4
3
![Page 9: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/9.jpg)
#PIWorld ©2019 OSIsoft, LLC 9
Design Tradeoffs
• Optimized for...• Streaming analytics use case• Real-time calculations take priority over recalculations• Easy configuration - no programming experience required
• Not suitable for...• Executing queries across really large number of attributes• Extracting large amounts of time series data• Ad-hoc calculations
![Page 10: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/10.jpg)
#PIWorld ©2019 OSIsoft, LLC#PIWorld ©2019 OSIsoft, LLC 10
Best Practices
![Page 11: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/11.jpg)
#PIWorld ©2019 OSIsoft, LLC 11
Building ExpressionsUse of variables
![Page 12: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/12.jpg)
#PIWorld ©2019 OSIsoft, LLC 12
Building ExpressionsUse of variables
Easily assign variables to expressions, by highlighting
and right-clicking on the highlighted text:
![Page 13: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/13.jpg)
#PIWorld ©2019 OSIsoft, LLC 13
Building ExpressionsComments
Use of comments in expressions helps with readability:
![Page 14: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/14.jpg)
#PIWorld ©2019 OSIsoft, LLC 14
Building ExpressionsExit early
If some expressions are not needed to be evaluated based
on same conditions, the Exit() function can be used:
![Page 15: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/15.jpg)
#PIWorld ©2019 OSIsoft, LLC 15
Historizing Data
Store data history into PI Points:
![Page 16: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/16.jpg)
#PIWorld ©2019 OSIsoft, LLC 16
Working with Multiple Values
Retrieve and filter data in your calculations:
![Page 17: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/17.jpg)
#PIWorld ©2019 OSIsoft, LLC 17
Templates
• Provide manageability, consistency and governance
• Use templates for any repetitive work or for future extensions.
• A modification to the template is applied to all analyses from that template.
• Searching and filtering in UI is also easier with templates.
• More performant.
![Page 18: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/18.jpg)
#PIWorld ©2019 OSIsoft, LLC 18
Evaluate
Perform an Evaluate to identify possible issues during
configuration:
![Page 19: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/19.jpg)
#PIWorld ©2019 OSIsoft, LLC 19
Preview
Preview calculation before checking in:
![Page 20: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/20.jpg)
#PIWorld ©2019 OSIsoft, LLC 20
Expensive Functions
•Some functions such as summary functions (TagAvg etc.) might require a lot of data in the past to perform a calculation.
•Optimizations can be made by using a smaller range or evaluating less often if the range is larger.
•Compression on PI points can also help with density of data.
![Page 21: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/21.jpg)
#PIWorld ©2019 OSIsoft, LLC 21
Event Frames and Notifications
•Utilize Event Frames to capture events.
•Good for reports, comparisons and tracking.
•Capture data points at the close of event frame.
![Page 22: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/22.jpg)
#PIWorld ©2019 OSIsoft, LLC 22
Event Frames and Notifications
•Get notified when an event starts and/or ends.
![Page 23: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/23.jpg)
#PIWorld ©2019 OSIsoft, LLC 23
Bulk Operations
![Page 24: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/24.jpg)
#PIWorld ©2019 OSIsoft, LLC 24
Recalculation/Backfilling
•Real-time vs Recalculation: Independent workers.
•Recalculate dependent analyses:
![Page 25: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/25.jpg)
#PIWorld ©2019 OSIsoft, LLC 25
Auto-Recalculation
•Enable auto-recalculation when:• Out of order data is expected and
• It is required to recalculate past data.
•Don't enable auto-recalculation when:• Past data shouldn't be modified
• Past data from dependent calculations shouldn't be modified.
![Page 26: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/26.jpg)
#PIWorld ©2019 OSIsoft, LLC 26
Change Management
•Consider setting up Dev or Test environment• Allows for experimentation while developing
calculations
• Many engineers could be writing calculations
• Frequent changes can cause some churn for the production system
• Easier to isolate issues
![Page 27: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/27.jpg)
#PIWorld ©2019 OSIsoft, LLC 27
High Availability
•PI Analysis Service supports failover using Windows Server Failover Clustering (WSFC)
•Use buffering for writing PI Point outputs (PI Buffer Subsystem)
![Page 28: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/28.jpg)
#PIWorld ©2019 OSIsoft, LLC 28
More Resources
• Incorporate Event Frames into Your Operations (up next!)
•PI Square (Asset Analytics Best Practices) https://pisquare.osisoft.com
![Page 29: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/29.jpg)
#PIWorld ©2019 OSIsoft, LLC 29
High Availability
•PI Analysis Service supports failover using Windows Server Failover Clustering (WSFC)
•Use buffering for writing PI Point outputs (PI Buffer Subsystem)
![Page 30: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/30.jpg)
#PIWorld ©2019 OSIsoft, LLC#PIWorld ©2019 OSIsoft, LLC 30
Summary
![Page 31: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/31.jpg)
#PIWorld ©2019 OSIsoft, LLC 31
Summary
1. Use variables
2. Use comments
3. Use the Exit() function
4. Save analysis output data to PI Points
5. Build Analytics on a template
6. Avoid expensive, frequently evaluated queries using summary functions such as TagAvg()
![Page 32: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/32.jpg)
#PIWorld ©2019 OSIsoft, LLC 32
Nathaniel Adebayo
Systems Engineer
OSIsoft LLC
![Page 33: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/33.jpg)
#PIWorld ©2019 OSIsoft, LLC
Questions?
Please wait for
the microphone
State your
name & company
Please remember
DOWNLOAD THE MOBILE APP
33
![Page 34: Techniques for Optimizing Asset Analytics · Asset Analytics Overview. #PIWorld ©2019 OSIsoft, LLC 4 Asset Analytics •150+ built in functions •Streaming calculations triggered](https://reader034.vdocuments.us/reader034/viewer/2022043006/5f8f85e3908037382f2e34de/html5/thumbnails/34.jpg)
#PIWorld ©2019 OSIsoft, LLC 34