Skip to main content
July 8, 2024
Solved

How does it work C#Aggregated

  • July 8, 2024
  • 2 replies
  • 0 views

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,

Best answer by T_Kress

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.

2 replies

July 8, 2024

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_KressAnswer
July 8, 2024

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.

danielAuthor
July 10, 2024

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.

 

July 10, 2024

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?