24 Replies Latest reply on May 30, 2018 8:21 PM by lovetolaugh

Asset Framework Tips and Tricks

mmckay Oct 21, 2015 6:47 PM

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!

Guide to Substitution Syntax in AF-EF Data References - v2.pdf 3.3 MB

Re: Asset Framework Tips and Tricks

j.rao Oct 10, 2015 4:35 PM (in response to mmckay)

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 Likes(0)

Actions
- Re: Asset Framework Tips and Tricks
  
  pthivierge Oct 22, 2015 4:57 PM (in response to j.rao)
  
  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 Likes(0)
  
  Actions
Re: Asset Framework Tips and Tricks

Roger Palmen Oct 21, 2015 8:51 AM (in response to mmckay)

Excellent work! Found all of my best practices in there.
Like Show 0 Likes(0)

Actions
Re: Asset Framework Tips and Tricks

flemoine Oct 21, 2015 2:15 PM (in response to mmckay)

many thanks for your work !!! very usefull document !
Like Show 0 Likes(0)

Actions
Re: Asset Framework Tips and Tricks

srobertson Oct 22, 2015 1:40 AM (in response to mmckay)

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 of 3 people found this helpful
Like Show 7 Likes(7)

Actions
- Re: Asset Framework Tips and Tricks
  
  lovetolaugh May 30, 2018 8:21 PM (in response to srobertson)
  
  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 Likes(0)
  
  Actions
Re: Asset Framework Tips and Tricks

Maciej Oct 22, 2015 4:39 AM (in response to mmckay)

Alex - great job
Like Show 0 Likes(0)

Actions
Re: Asset Framework Tips and Tricks

lmlcoch Oct 22, 2015 3:56 PM (in response to mmckay)

Great reference guide! Thanks for sharing
Like Show 0 Likes(0)

Actions
Re: Asset Framework Tips and Tricks

pthivierge Oct 22, 2015 5:01 PM (in response to mmckay)

This is a huge work Maxime McKay, thanks for sharing that document! This will definitely become a good reference.
Like Show 0 Likes(0)

Actions
Re: Asset Framework Tips and Tricks

howardh Oct 23, 2015 1:32 PM (in response to mmckay)

REALLY appreciated!!! THANKS!
Like Show 0 Likes(0)

Actions
Re: Asset Framework Tips and Tricks

James Devine Nov 13, 2015 9:56 PM (in response to mmckay)

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 Likes(3)

Actions
Re: Asset Framework Tips and Tricks

ksward Apr 13, 2016 2:37 PM (in response to mmckay)

Excellent, can you expand it to add examples of the functions within Formula and String Builder, starting the the command syntax.
Like Show 0 Likes(0)

Actions
Re: Asset Framework Tips and Tricks

jagdish.konathala Apr 20, 2016 6:57 PM (in response to mmckay)

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 Likes(0)

Actions
- Re: Asset Framework Tips and Tricks
  
  bbregenzer Apr 22, 2016 1:43 AM (in response to jagdish.konathala)
  
  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 of 2 people found this helpful
  
  Like Show 3 Likes(3)
  
  Actions
Re: Asset Framework Tips and Tricks

VijayaBhaskar Jun 5, 2017 9:37 AM (in response to mmckay)

Greatly appreciate for this document , very useful one.

Thanks
Vijay
Like Show 0 Likes(0)

Actions
Re: Asset Framework Tips and Tricks

Bille Jun 5, 2017 4:01 PM (in response to mmckay)

Hello All . Am a Beginner with PI AF. Is there any link for this Training.

Best Regards

Bill
Like Show 0 Likes(0)

Actions
- Re: Asset Framework Tips and Tricks
  
  Camille Metzinger Jun 5, 2017 5:07 PM (in response to Bille)
  
  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
  Configuring Analytics with PI AF
  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 of 1 people found this helpful
  
  Like Show 1 Likes(1)
  
  Actions
- Re: Asset Framework Tips and Tricks
  
  bbregenzer Jun 6, 2017 1:58 AM (in response to Bille)
  
  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 of 2 people found this helpful
  
  Like Show 1 Likes(1)
  
  Actions
  - Re: Asset Framework Tips and Tricks
    
    Bille Jun 7, 2017 9:16 AM (in response to bbregenzer)
    
    Thanks Brent..
    
    Like Show 0 Likes(0)
    
    Actions
Re: Asset Framework Tips and Tricks

Vinit_Shah Jun 7, 2017 6:09 AM (in response to mmckay)

Kudos guys will help a lot of people for sure
Like Show 0 Likes(0)

Actions
Re: Asset Framework Tips and Tricks

Peres Jun 22, 2017 7:01 PM (in response to mmckay)

Guys,
I need know what different the TimeMethod.... Someone have a help book??
Like Show 0 Likes(0)

Actions
- Re: Asset Framework Tips and Tricks
  
  James Devine Jun 22, 2017 7:17 PM (in response to Peres)
  
  Olá Tiago:
  Tente isso:
  https://techsupport.osisoft.com/Downloads/File/729c11e5-0bcd-47fb-82bf-127c5de19a7e
  
  (em Português)
  
  Like Show 1 Likes(1)
  
  Actions
- Re: Asset Framework Tips and Tricks
  
  Roger Palmen Jun 23, 2017 6:57 AM (in response to Peres)
  
  This KB Article is also quite helpful in a good understanding of the behaviour: Request Rejected
  
  Like Show 1 Likes(1)
  
  Actions
  - Re: Asset Framework Tips and Tricks
    
    Peres Jun 29, 2017 1:25 PM (in response to Roger Palmen)
    
    Excellente!!!!Thanksssss
    
    Like Show 1 Likes(1)
    
    Actions