Forum Discussion

daniel's avatar
daniel
New Contributor
5 months ago

How does it work C#Aggregated

Hi,

How does it work the C#Aggregated?

What entity property does it take into account for aggregating?

We are aggregating two different entity structures but we are not obtaining the same data. We have the same entities in both structures but one of the has duplicated two entities:

- one of them aggregates OK.

- the other, does not.

Regards,

Consolidation
Cubes
  • T_Kress's avatar
    T_Kress
    5 months ago

    If your hierarchies have identical base members, with no duplicates, and all % ownerships are the same, then the answer at the top of the hierarchy when aggregated (assuming aggregating with no base data changes in between) will be the same (unless you have a calculation that is different for a base entity with one parent than a base entity with another parent).

    In the Open Place there is a tool that quickly allows you to compare two entity hierarchies to ensure they have the same base members and no duplicated entities.  It is called "Hierarchy Validation Tool" and it is quite useful to check the hierarchies.  It may help you in this case identify your issue.

  • aformenti's avatar
    aformenti
    Contributor II
    5 months ago

    HI daniel,

    The C#Aggregated would take into account both the Local Entity Currency to derive the translated values as well as the % of Consolidation on the Entity Relationship properties. 

    Hope that helps, 

    Albert 

  • T_Kress's avatar
    T_Kress
    Contributor III
    5 months ago

    If your hierarchies have identical base members, with no duplicates, and all % ownerships are the same, then the answer at the top of the hierarchy when aggregated (assuming aggregating with no base data changes in between) will be the same (unless you have a calculation that is different for a base entity with one parent than a base entity with another parent).

    In the Open Place there is a tool that quickly allows you to compare two entity hierarchies to ensure they have the same base members and no duplicated entities.  It is called "Hierarchy Validation Tool" and it is quite useful to check the hierarchies.  It may help you in this case identify your issue.

    • daniel's avatar
      daniel
      New Contributor
      5 months ago

      If I have the same members in both structures, no problem, it does fine.
      If I have duplicate members in one of the two structures but the consolidation percentage is set to 100 in one and 0 in the duplicate, there is no problem either. So it works fine now.

      The problem came because I had 100% in both duplicate members of the same structure so it was duplicating the data.

       

      • T_Kress's avatar
        T_Kress
        Contributor III
        5 months ago

        This is the expected/correct behavior.  If you add an entity twice into a hierarchy, the data will double.  Sounds like you are okay then once you fixed the structure?