• State Not Answered
  • +1 person also asked this people also asked this
  • Replies 11 replies
  • Subscribers 15 subscribers
  • Views 573 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
  • 0

    Just adding a thought, could Object Wizards help you structure your model.

    With the later versions of SP, Wizards options can be configured by the import feature.

  • 0 in reply to Jakob Drescher

    Hello Jakob, 

    Thank you for putting forth your views here. The challenge is not here to structure the model, rather we have already defined and beautifully structured it. It's the need of aggregating attribute values from child objects like kW at parent (Area Object Level) w/o specifying each object in scripting.

  • 0 in reply to Lakshay Mundeja

    why not just....

    1) add a string array to your Area (to store list of objects in the area)

    2) manually store/upload list of names of the objects for that area to the array (script it if you want from CSVXML file) 

    3) in the Area have a script that only runs when string array.Dimension1 >= 1 and then use a loop though the array in script and then for each string use the Indirect method to get your values and then you can sum of all the configured string points and store in the area totals.  

    4) run it periodically

    > I have done a couple of project going one step further and each Object in the area populate its own object name in the area so it auto configures the array on deployment of the object but you need to check for duplicates and errors

Reply
  • 0 in reply to Lakshay Mundeja

    why not just....

    1) add a string array to your Area (to store list of objects in the area)

    2) manually store/upload list of names of the objects for that area to the array (script it if you want from CSVXML file) 

    3) in the Area have a script that only runs when string array.Dimension1 >= 1 and then use a loop though the array in script and then for each string use the Indirect method to get your values and then you can sum of all the configured string points and store in the area totals.  

    4) run it periodically

    > I have done a couple of project going one step further and each Object in the area populate its own object name in the area so it auto configures the array on deployment of the object but you need to check for duplicates and errors

Children
No Data
© 2024 AVEVA Group plc and its subsidiaries. All Rights Reserved.