Asset Framework Tips and Tricks

Discussion created by mmckay

on Oct 9, 2015
Latest reply on May 30, 2018 by lovetolaugh

Like • Show 24 Likes24
Comment • 24

Hello everyone,

We are a bunch of Asset Framework fans within OSIsoft that have been looking for a way to share our Tips and Tricks with the greater OSIsoft community. These are things we learned while working with customers on real-world scenarios, solving simple and not so simple problems...

Attached to this post is a document on Asset Framework and Event Frames Substitution Syntax which we think will be useful to many. We hope this is the first of many more to come.

Kudos to Ales Soudek - aka AF guru for writing it up...

We thought some of you might also be able to share their tips and tricks so we that we can gather them all at one place. Please share any fancy thing you did in AF!

Attachments

Guide to Substitution Syntax in AF-EF Data References - v2.pdf3.3 MB

Outcomes

24 Replies

j.rao Oct 10, 2015 4:35 PM
Fantastic reference! Very exhaustive document

I wish there is one for querying AF using OLEDB ENT. While we use them, I think it can be fairly optimized.
Like • Show 0 Likes0
Actions
- pthivierge @ j.rao on Oct 22, 2015 4:57 PM
  Hello Jagadish,
  
  There is actually a whitepaper that exist on this topic, are you saying it could be optimized?
  
  Thanks in advance for you comment!
  Like • Show 0 Likes0
  Actions
Roger Palmen Oct 21, 2015 8:51 AM
Excellent work! Found all of my best practices in there.
Like • Show 0 Likes0
Actions
flemoine Oct 21, 2015 2:15 PM
many thanks for your work !!! very usefull document !
Like • Show 0 Likes0
Actions
srobertson Oct 22, 2015 1:40 AM
One of tips that I like to use is "always ask your parent". Avoid using syntax such as '..\..\..\|SiteName". Instead create a template that defines the attribute "SiteName as '..\|SiteName'. Add this template as base template to your other templates. This prevents the hard-coding of the relationship in the AF structure. Elements can be placed in any position in the structure without breaking any references, because the parent always knows! Another benefit is that adding additional Attributes can easily be propagated throughout the structure by making the change in only one template.
3 people found this helpful
Like • Show 7 Likes7
Actions
- lovetolaugh @ srobertson on May 30, 2018 8:21 PM
  Can you provide an example database using the base template you mentioned.
  "Instead create a template that defines the attribute "SiteName as '..\|SiteName'"
  Like • Show 0 Likes0
  Actions
Maciej Oct 22, 2015 4:39 AM
Alex - great job
Like • Show 0 Likes0
Actions
lmlcoch Oct 22, 2015 3:56 PM
Great reference guide! Thanks for sharing
Like • Show 0 Likes0
Actions
pthivierge Oct 22, 2015 5:01 PM
This is a huge work Maxime McKay, thanks for sharing that document! This will definitely become a good reference.
Like • Show 0 Likes0
Actions
howardh Oct 23, 2015 1:32 PM
REALLY appreciated!!! THANKS!
Like • Show 0 Likes0
Actions
James Devine Nov 13, 2015 9:56 PM
I took Ales Soudek's "Asset Framework Tips and Tricks" class at the last Users Conference. I am a keyboard shortcut enthusiast and have enjoyed my new skills ever since. I keep the handbook that was given away then on my desk at all times. Ales is an especially good instructor.
Like • Show 3 Likes3
Actions
ksward Apr 13, 2016 2:37 PM
Excellent, can you expand it to add examples of the functions within Formula and String Builder, starting the the command syntax.
Like • Show 0 Likes0
Actions
jagdish.konathala Apr 20, 2016 6:57 PM
Not sure if regular expressions are supported. Couldn't find much info there. If an element is named 'Bus 1 138' (Bus template) , how can I extract 'Bus' and '1' separately and use them as substitution parameters for its attribute? I currently have \\%Server%\%..\Element%.%Element%.%Description%. This forms a tag Substation12.Bus 1 138.KVA but I want it to be Substation12.BUS.1.KVA . How do I extract 'Bus' from element name and upper case it? Is it possible?
Like • Show 0 Likes0
Actions
- bbregenzer @ jagdish.konathala on Apr 22, 2016 1:43 AM
  Hi, Jagdish.
  We don't have full-blown RegEx in AF but there are some options. What version of AF are you using? In 2.6 and later, we have the String Builder DR:
  https://livelibrary.osisoft.com/LiveLibrary/content/en/server-v6/GUID-A8FA993F-9028-4398-8F41-A9839DFD3F29
  Also, as of 2.6, we have some string functions built into in asset analytics:
  https://livelibrary.osisoft.com/LiveLibrary/content/en/server-v6/GUID-BA58EDF5-C70A-4503-A569-83B9C142C349
  I believe the Left, InStr, and UCase functions could be used to get the pieces you need into attributes that could then be referenced. Also, if you have AF 2.7 or later, you can hide these attributes so they won't clutter the end users' views.
  2 people found this helpful
  Like • Show 3 Likes3
  Actions
VijayaBhaskar Jun 5, 2017 9:37 AM
Greatly appreciate for this document , very useful one.

Thanks
Vijay
Like • Show 0 Likes0
Actions
Bille Jun 5, 2017 4:01 PM
Hello All . Am a Beginner with PI AF. Is there any link for this Training.

Best Regards

Bill
Like • Show 0 Likes0
Actions
- Camille Metzinger @ Bille on Jun 5, 2017 5:07 PM
  Hi Bill,
  
  If you're new to AF, then you might find some of the content in our online courses or YouTube videos on AF helpful:
  Building Asset Hierarchies with PI AF Discussion Forum
  Configuring Analytics with PI AF Discussion Forum
  Asset Analytics with PI AF (Asset Framework) - YouTube
  
  You can check out the content in the online courses on your own at any time or register for them if you want a facilitated session.
  
  Thanks,
  Camille
  1 person found this helpful
  Like • Show 1 Like1
  Actions
- bbregenzer @ Bille on Jun 6, 2017 1:58 AM
  Hi, Bill.
  In addition to the great resources Camille suggested, you might also be interested to know that this paper was turned into a TechCon lab the last two years at the UC. Here is a link to the 2017 version of the workbook:
  Request Rejected
  I think the VM for the class is also available through the VLE on our Learning site if you have a VLE subscription.
  Welcome to the wonderful world of AF!
  2 people found this helpful
  Like • Show 1 Like1
  Actions
  - Bille @ bbregenzer on Jun 7, 2017 9:16 AM
    Thanks Brent..
    Like • Show 0 Likes0
    Actions
Vinit_Shah Jun 7, 2017 6:09 AM
Kudos guys will help a lot of people for sure
Like • Show 0 Likes0
Actions
Peres Jun 22, 2017 7:01 PM
Guys,
I need know what different the TimeMethod.... Someone have a help book??
Like • Show 0 Likes0
Actions
- James Devine @ Peres on Jun 22, 2017 7:17 PM
  Olá Tiago:
  Tente isso:
  https://techsupport.osisoft.com/Downloads/File/729c11e5-0bcd-47fb-82bf-127c5de19a7e
  
  (em Português)
  Like • Show 1 Like1
  Actions
- Roger Palmen @ Peres on Jun 23, 2017 6:57 AM
  This KB Article is also quite helpful in a good understanding of the behaviour: Request Rejected
  Like • Show 1 Like1
  Actions
  - Peres @ Roger Palmen on Jun 29, 2017 1:25 PM
    Excellente!!!!Thanksssss
    Like • Show 1 Like1
    Actions

Asset Framework Tips and Tricks

Attachments

Outcomes

Related Content

Recommended Content

Incoming Links