Visual Builder

Get Involved. Join the Conversation.


    Ziv Rubin
    Automatic Calculation of Other BO Aggregation
    Topic posted June 20, 2019 by Ziv RubinBronze Medal: 1,250+ Points, tagged Business Objects, REST 
    19 Views, 1 Comment
    Automatic Calculation of Other BO Aggregation
    How to automatically fill BO with another aggregate BO

    Hi All,

    I have a BO which I need to populate with a count of another BO's specific fields?

    BO-A - (100 rows)

    Fields: UserName(string), Category(string), ...

    BO-B (4 rows of unique categories)

    Fields: Category(string), Counter(number)


    I want to "group-by" all categories from BO-A to appear in Counter field of BO-B.

    I tried using a reference field with no success as performed here:

    Any suggestions?






    • Shay Shmeltzer

      Two options

      Either use a parent/child relationship defining the category field in BO-A to reference the category field in BO-B and then defining an aggregated count field in BO-B.

      Or use BO triggers on BO-A to update a field in BO-B each time data is manipulated in BO-A.