• AF Analytics - Filtered calculations

    How to create filtered averages, totals, and rollupsCalculations like an average of a set of data, but only when the values are above a certain threshold cannot be done directly with the built in functions in Analytic...
    asoudek
    last modified by asoudek
  • AF Analytics - Pass parameters using Attributes

    Make your calculations more robust by using Attributes instead of hard coding values in the expressionsWhen writing an expression it is not a good idea to hard code things like upper/lower limits, time ranges, and oth...
    asoudek
    last modified by asoudek
  • Create PI Point with custom UOM stored in the Attribute in a Template

    I just found tricky issue. Imagine that you have template in the AF. Something like this: And you want to create this PI Point from AF with custom UOM stored in the UOM_name attribute. You probably would like to ...
    wpribula
    last modified by wpribula
  • AF Analytics - Bad and/or Stale Value Filters

    Check for system digital states before using them in calculations.  Validate whether the value is stale.When dealing with real life systems it is highly unlikely that you will always have good data for your calcu...
    asoudek
    last modified by asoudek
  • Step triggered Event Frame - easy and smoothly

    (Since AF 2018 we supports step and pulse triggering - for more please see this: Implicit modes of event frame generation in asset analytics) Event Frames step triggering is not available in the PSE (PI System Explor...
    wpribula
    last modified by wpribula
  • Tips and Tricks for Asset Based Analytics

    Asset Based Analytics take four forms: Expressions Event Frame generation Roll ups SQC (not covered in this document yet) This is a very powerful feature of the PI Asset Framework (PI AF), but there are not man...
    asoudek
    last modified by asoudek
  • Exporting AF Databases using PowerShell

    We recently had an issue with some inadvertent deletions from our AF database. Recovering was challenging - and it would have been so much easier if we had had a plain export of our database, that we could have impor...
    Jarita Sirois
    created by Jarita Sirois
  • AF Analytics - NoOutput() Function

    Prevent writing the same value to a PI TagWe used this function in several examples above.  The main thing to be aware about this function is that it is only supported for expressions where the result of the expr...
    asoudek
    last modified by asoudek
  • AF Analytics - Working with date-time arithmetic

    Understand how to use date-times in your expressionsUsing date-time in Analytic Expressions looks straight forward, but you can get yourself in a jam if you do not know the tricks.  Suppose you want to calculate ...
    asoudek
    last modified by asoudek
  • URI Builder - PI Coresight Link

    I recently wrote up a short introduction to using the URI builder Data Reference to create links to google maps. Here, I wanted to do the same to build a PI Coresight Ad Hoc display.   Ad Hoc displays are limite...
    Jerome Lefebvre
    last modified by Jerome Lefebvre
  • Performing a Simple Balance using AF and Event Frames

    The following document describes an example of using AF and Event Frames for perform and report on a simple volume balance.  This can be applied to a mass or energy balance.
    asoudek
    last modified by asoudek
  • Make AF Analytics more readable - Break up your calculations

    Make your calculations more readable and understandableIt is not easy to try to read and understand an equation that is very long (those of you who have experience with the PI Performance Equations can attest to this)...
    asoudek
    last modified by asoudek
  • Localizing the AF Example kits - Part 1 - Exporting a database

    This is an ongoing series introducing the various code examples I and others have created in the goal of localizing the various AF example kits. Series: Part 0: URI Builder data reference in AF 2016 Part 1: Exporti...
    Jerome Lefebvre
    created by Jerome Lefebvre
  • Localizing the AF Example kits - Part 2 – Fixing analysis mapping after import

    This is an ongoing series introducing the various code examples I and others have created in the goal of localizing the various AF example kits. Series: Part 0: URI Builder data reference in AF 2016 Part 1: Localizing...
    Jerome Lefebvre
    last modified by Jerome Lefebvre
  • AF Analytics - Advanced write back

    Write the results of your expressions to a time other than the trigger timeA new feature in AF 2.7 (and later versions) is the ability to put the results of an analysis at a different time other than the execution tim...
    asoudek
    last modified by asoudek
  • URI Builder data reference in AF 2016

    I and several others in OSIsoft (chiefly among them Jason Jian-Hao Lu and Akane Takezaki) are currently working on localizing the AF Example kits and I promised a series of blog post to document the process. To get m...
    Jerome Lefebvre
    last modified by Jerome Lefebvre
  • AF Analytics - How to use Attributes from other Elements

    (Use Attributes from other Elements in your expressions)In some situations, there is a need to include Attributes from other Elements in the expression.  A typical example is a Parent-Element will contain informa...
    asoudek
    last modified by asoudek
  • AF Analytics - On Demand calculations

    Create calculations that are not stored in a PI Tag and understand which functions are supported for thisSometimes it is desirable to perform calculations but not to store them in a PI tag.  This is done by creat...
    asoudek
    last modified by asoudek
  • AF Analytics - Commenting your work

    Insert comments into your Variables so you and others can understand what you did laterHave you ever written an equation or a piece of code that made sense to you at the time only to come back a few weeks later (or in...
    asoudek
    last modified by asoudek
  • Localizing the AF Example kits - Part 3 - Reset to Template

    This is an ongoing series introducing the various code examples I and others have created in the goal of localizing the various AF example kits. Series: Part 0: URI Builder data reference in AF 2016 Part 1: Localizing...
    Jerome Lefebvre
    last modified by Jerome Lefebvre