9 Replies Latest reply on Nov 11, 2015 6:37 PM by henderson

    Expression with tags from different servers

    henderson

      Dear,

       

      I have the following problem.

       

      I have a PI TAG at one server, lets call FlowTAG at server PIsrv1.It returns the flow rate of a system.

       

      I have another PI TAG at other server, lets call ValveTAG at server PIsrv2.

      It returns the status of a valve. 0 = closed; 1 = open.

       

      What I need is to have a TAG that will return the FlowTAG average in the last 24 hours, but there is one conditional.

       

      For each sample of the average, the flow will be considered zero if ValveTag is zero. If ValveTag is 1, then the flow will be FlowTAG.

       

      I need this information on Excel, so I will use datalink. It would be better to have a TAG, but if it's the only option, it could be using AF.

       

      If TAGs were on the same server, I would just do this on Datalink:

      =PIAdvCalcExpVal("FlowTag'*'ValveTag'";"*-24h";"*";"average";"event-weighted";"compressed";"10m";0;1;0;"")

       

      But since they are on different PI servers, I think the only way to do this is using AF.

       

      How can I do this? AF is really the only option?

        • Re: Expression with tags from different servers
          gregor

          Hello Henderson,

           

          May I ask why the flow rate is recorded at PIsrv1 and the valve Position on PIsrv2?

          Personally I wouldn't feel comfortable about this and recommend to at least consider replicating either point to the other server if moving it is no option.

          The following syntax allows you to refer a PI Point on a specific PI Data Archive node directly but I am not sure if the time filtering works because this is usually done server side and I wouldn't know PIsrv1 would reach out to PIsrv2 for the valve position:

           

               \\PIsrv1\FlowRate 

            • Re: Expression with tags from different servers
              henderson

              Hello Gregor,

               

              The flow rate is not a real flow rate. Its a simulation that comes from a system that simulates a estimated flow. This system does not see the status of the valve, so it keeps outputting a flow rate even if the valve is off. Thats why we need to check the valve status to consider the simulated flow rate.

               

              I already tried using this sintax on datalink, with the following expression, but it gives me an erros saying I can't have points from different servers at one single expression.

               

              =PIAdvCalcExpVal("\\PIsrv1\FlowTag'*'\\Pisrv2\ValveTag'";"*-24h";"*";"average";"event-weighted";"compressed";"10m";0;1;0;"")

               

              Moving from one server to another is not an option (I don't know the reason. Our IT team says it must remain on different servers).

              On server has only data from many other systems (like this simulating system) and the other servers has the data from the process (that's where we need to get the valve status from)

               

              I am not sure how this replication option would work. Could explain it better?

              I am not a PI administrator, I am just an end user.

               

              I asked the administrator team to give me a solution to this but they are having a hard time so I decided to try to find a solution here because I know from previous questions that you guys are awesome.

                • Re: Expression with tags from different servers
                  jking

                  Hi Henderson,

                  There are two options for you:

                   

                  1) Retrieve all the raw data into your Excel spreadsheet.  Then do the multiplication and the event-weighted average using Excel math functions

                  2) Use AF and create two PIPoint DR attributes to point to the two tags.  Then create a Formula attribute to do the multiplication.  And then use DataLink summary call on the Formula attribute.

                   

                  There may be other options but those are the two I can think of off the top of my head.

                   

                  I hope this helps,

                  Jason

                    • Re: Expression with tags from different servers
                      henderson

                      All users are in a satellite internet connection, which is very slow due to high latency, so I am going to the second option.

                       

                      In fact, I already have what you suggested.

                      An then I use datalink to calculate the average.

                       

                      I was hopping to find a way to calculate the average in this Formula attribute in AF, this way on Datalink I would only use ArcVal function.

                       

                      The only reason to do this is because, like I said, the users have a very slow internet connection and ArcVal looks to work much better than calculating an average.

                • Re: Expression with tags from different servers
                  henderson

                  Guys,

                   

                  Do you think this could work?

                  OSIsoft: How to Setup Expression Analyses with PI AF [PI AF 2014- v2.6.0.5843] - YouTube

                   

                  I was think to create an attribute with an expression like this:

                  'FlowTag'*'ValveTag'

                   

                  And then use analyses to calculate the average in the last 24 hours (starting at '*-24h' until '*')

                    • Re: Expression with tags from different servers
                      dng

                      Hi Henderson,

                       

                      What you are suggesting will work. You can also map the output of the analysis to a PI tag (if history is required) and pull in the values into DataLink.

                       

                      One caveat that I could think of: when you multiply flow tag to valve tag (FlowTag*ValveTag) in an expression (e.g. formula), you are essentially multiplying the two values at every timestamp where archive values exist for either tag. e.g.

                      Flow tag (non-step):

                      12:00:00   10

                      12:01:00   20

                      12:02:00   30

                       

                      Valve tag (step):

                      11:59:30    0

                      12:00:30    1

                      12:01:30    0

                      12:02:30    1

                       

                      Flow tag * valve tag (non-step):

                      11:59:30    0

                      12:00:00    0

                      12:00:30    10

                      12:01:00    20

                      12:01:30    0

                      12:02:00    0

                      12:02:30    30

                       

                      Taking a time-weighted average of the flow tag * valve tag (above) is different from taking the time-weighted average of the following (below):

                      11:59:30    0

                      12:00:00    0

                      12:00:30    from 0 to 10

                      12:01:00    20

                      12:01:30    from 20 to 0

                      12:02:00    0

                      12:02:30    from 0 to 30

                       

                      I'm not sure which condition you are looking for in your final results, but just make sure the boundary conditions satisfy what you are trying to calculate.

                      1 of 1 people found this helpful
                        • Re: Expression with tags from different servers
                          henderson

                          Would not be a problem this boundary, but what I did was the following.

                           

                          Created an attribute: RealFlow = FlowTag * ValveTag with stepped = True

                           

                          And then, created an analyses to calculate the average from RealFlow.

                          Also mapped the output to a TAG so we have history and can pull it using PiArcVal in Datalink.

                           

                          This way I think I won't have that "transition" problem when the TAG is going from some value to 0 or from 0 to some value. Right?

                           

                          Glad I found this solution. It was causing a lot of problem for us.