How does it work C#Aggregated

[daniel]

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,

[aformenti]

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 · Accepted solution]

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]

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]

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?