AVEVA™ PI System™ Feedback Portal

Welcome to our new feedback site!


We created this site to hear your enhancement ideas, suggestions and feedback about AVEVA products and services. All of the feedback you share here is monitored and reviewed by the AVEVA product managers.

To start, take a look at the ideas in the list below and VOTE for your favorite ideas submitted by other users. POST your own idea if it hasn’t been suggested yet. Include COMMENTS and share relevant business case details that will help our product team get more information on the suggestion. Please note that your ideas and comments are visible to all other users.


This page is for feedback specifically for AVEVA PI System. For links to our other feedback portals, please see the tab RESOURCES below.

Add a new idea Subscribe
Status Declined
Product AVEVA™ PI Server
Categories PI Builder
Created by Kenneth Barber
Created on Aug 20, 2022

RELATED IDEAS

Minimize the recalculation of volatile cells

Currently, PI Builder data is imported row by row. Each imported row causes all volatile cells in all open workbooks and any cells downstream of them in the dependency tree to recalculate. PI Builder will not import a new row until this calculation is complete. If there are too many slow-calculating downstream cells, the entire import can be slowed to a crawl. Please consider importing data in a way that does not trigger the recalculation of volatile cells as often. One option is to switch to manual calculation before the import and restore the previous calculation mode after the import. Another option is to store the retrieved rows in memory and then write all of the rows at once to the sheet after the import is complete.
  • ADMIN RESPONSE
    Aug 20, 2022
    Thank you very much for sharing your feedback on the PI Server. After further evaluation, we have decided to decline this item, as we are not planning on implementing it in the near future due to other high priority items across the PI System. Thank you for your feedback, and know that we are listening and reviewing every item that gets submitted!
  • Attach files
  • Kenneth Barber
    Reply
    |     Aug 20, 2022
    Volatile cells recalculate essentially whenever any change to any cell is made. Any cell that uses a volatile function (e.g. NOW, TODAY, RAND, RANDBETWEEN) is volatile. By "write all of the rows at once", I mean that you can do something like "Sheet1.Cells(1,1).Resize(3, 5).Value = v" in VBA, if v is a Variant variable or Variant array with 3 rows and 5 columns. You do not need to loop cell by cell or row by row to assign values to a multi-row, multi-column range. I'm open to any questions.