AnsweredAssumed Answered

How the best way to create a report that show only digital tags in state "ON"?

Question asked by emladeira on Aug 13, 2015
Latest reply on Aug 17, 2015 by emladeira

Like • Show 0 Likes0
Comment • 5

Hello all:

In our process we have some bypass PI tags and I need to generate a report that show what tags are in bypass at this moment and a weekly report with total time for each tag in that condition.

I created that structure in MS Excel but it was very slow and I don't want to write a specific application.

Any suggestions?

Regards,

Eduardo Ladeira

No one else has this question

Outcomes

5 Replies

Marcos Vainer Loeff Aug 13, 2015 6:08 PM
Mark Correct
Correct Answer
Hi Eduardo,

I have a few questions for you:
1. What do you mean by "bypass PI tags"?
2. Do you want to keep using MS Excel? As you don't want to develop an application, which options are acceptable to you?
3. Which technologies are you currently using on your spreadsheet?
Like • Show 0 Likes0
Actions
- emladeira @ Marcos Vainer Loeff on Aug 14, 2015 11:46 AM
  Mark Correct
  Correct Answer
  Marcos:
  
  1 - Bypass tags are digital tags configured on PI as "ON" or "OFF".
  
  2 - We have up to 3K bypass tags for each process plant. MS Excel is the best way to do this? I think to use AF but now I don't know how to do.
  
  3 - I built it using PI DataLink functions.
  
  Regards,
  
  Eduardo Ladeira
  Like • Show 0 Likes0
  Actions
  - Marcos Vainer Loeff @ emladeira on Aug 14, 2015 12:53 PM
    Mark Correct
    Correct Answer
    Hello Eduardo,
    
    Here are some suggestion for you in order to improve performance:
    
    Upgrade to PI DataLink 2015. If you have an old version of the product which uses PI SDK instead of PI AF SDK, you shall get better performance will the most recent versions of PI DataLink.
    
    It is better to use bulks calls if possible against the PI System. I would check if it is possible to use this functionality on your spreadsheet. This thread provide useful information about Datalink 2015 - Bulk Calls.I guess TechSupport can help you analyze your spreadsheet and maybe provide a better alternative for you.
    
    If this is taking a lot of time because many calculations are done on the client-side, I would use PI Asset Based Analytics in order to move those calculations to the server-side, saving the results back on PI Points. Then, only the final calculation results will be transferred to the client and not all the time series values from the selected time period which will be faster.
    
    Finally, you might achieve better performance by writing custom code with PI AF SDK, showing the results on a web server for instance. But I understand that you want to avoid this path.
    
    Hope it helps!
    Like • Show 0 Likes0
    Actions
  - Marcos Vainer Loeff @ emladeira on Aug 14, 2015 1:00 PM
    Mark Correct
    Correct Answer
    You might also want to read these threads: Re: slow excel datalink and Workaround for very slow connections
    Like • Show 0 Likes0
    Actions
    - emladeira @ Marcos Vainer Loeff on Aug 17, 2015 11:54 AM
      Mark Correct
      Correct Answer
      Marcos:
      
      RtReports could be a solution?
      Like • Show 0 Likes0
      Actions

How the best way to create a report that show only digital tags in state "ON"?

Outcomes

Related Content

Recommended Content