• State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 13 replies
  • Subscribers 20 subscribers
  • Views 1567 views
  • Users 0 members are here
Options
Related

Value Roll Ups to Area Objects

Lakshay Mundeja

What will be the best way to roll up values ( for some specific attributes) from child objects to Area Objects in System Platform. The way must be dynamic (static scripting with + is not suitable) as the child objects could be added or deleted in the area or could be reassigned to a different area. As an eg, my Data Hall is an Area Object, which has Cabinets having kW attribute in it. It is required to have sum of all kW at Data Hall level. This is very easily done in PI with simple steps of configuration but couldn't find anything much simpler in System Platform

Parents
  • +1

    I did this same thing for a client. I just queried the galaxy database to get the list of contained objects for the given object/area and stored those in a local attribute as a csv string. This script would run only when the object starts up. Then I add another script that will execute periodically, iterate the object list/csv, bind to the object using indirect, and sum the values up into another local attribute. This way all I need to do is add/remove the child objects, redeploy the tree, and it will automatically aggregate the data for me. It would be nice if there was an easier way. It's definitely not a non-programmer friendly approach, but it does make for a nice loosely coupled setup.

  • 0 in reply to Timothy Nunnink

    Hello Tim, thanks for the answer. This is the exact method we ended up using even though support screams when we over user Indirect Binding and that's why the need for more inbuilt method.

Reply Children
No Data
© 2025 AVEVA Group Limited or its subsidiaries. All Rights Reserved.