-
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.
-
Re: Asset Framework Tips and Tricks
pthiviergeOct 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!
-
-
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.
-
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 !
-
Re: Asset Framework Tips and Tricks
srobertsonOct 22, 2015 1:40 AM (in response to mmckay)
3 of 3 people found this helpfulOne 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.
-
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'"
-
-
Re: Asset Framework Tips and Tricks
Maciej Oct 22, 2015 4:39 AM (in response to mmckay)Alex - great job
-
Re: Asset Framework Tips and Tricks
lmlcochOct 22, 2015 3:56 PM (in response to mmckay)
Great reference guide! Thanks for sharing
-
Re: Asset Framework Tips and Tricks
pthiviergeOct 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.
-
Re: Asset Framework Tips and Tricks
howardh Oct 23, 2015 1:32 PM (in response to mmckay)REALLY appreciated!!! THANKS!
-
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.
-
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.
-
Re: Asset Framework Tips and Tricks
jagdish.konathalaApr 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?
-
Re: Asset Framework Tips and Tricks
bbregenzerApr 22, 2016 1:43 AM (in response to jagdish.konathala)
2 of 2 people found this helpfulHi, 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:
Also, as of 2.6, we have some string functions built into in asset analytics:
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.
-
-
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
-
Re: Asset Framework Tips and Tricks
BilleJun 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
-
Re: Asset Framework Tips and Tricks
Camille MetzingerJun 5, 2017 5:07 PM (in response to Bille)
1 of 1 people found this helpfulHi 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
-
Re: Asset Framework Tips and Tricks
bbregenzerJun 6, 2017 1:58 AM (in response to Bille)
2 of 2 people found this helpfulHi, 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:
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!
-
Re: Asset Framework Tips and Tricks
BilleJun 7, 2017 9:16 AM (in response to bbregenzer)
Thanks Brent..
-
-
-
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
-
-
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)
-
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
-
Re: Asset Framework Tips and Tricks
Peres Jun 29, 2017 1:25 PM (in response to Roger Palmen)Excellente!!!!Thanksssss
-
-