Forum Discussion

AndreaF's avatar
AndreaF
Contributor III
2 years ago

Alternative hierachies consolidation

Hi, my Entity dimension has a main hierarchy with TopMemberA being the top member, and an alternative hierarchy with TopMemberB as top member. It looks like this:   TopMemberA - ParentA1 --...
Consolidation
  • Henning's avatar
    Henning
    2 years ago

    Hi, what do you mean by "consolidate", exactly? What you describe is the expected behavior when you use "Force Consolidate" - provided that everything else stays the same, and no data has been loaded or entered in the meantime between your two consolidate operations.

    A "Force Consolidate" impacts all entities below the entity you force consolidate, hence, changing the calculation status for your alternate hierarchy. When you use a simple "Consolidate", it should not impact the calc status of the alternate hierarchy. If you consolidate using workflow process, make sure to check what the process step has been set to use (force or normal consolidate). 

    If you were already aware of that and ran your tests as needed, there may also be e.g. a business rule impacting the status of entities even though you only use a normal consolidate. But that needs a deeper dive into the solution.

Henning's avatar
Henning
Valued Contributor II

Hi, what do you mean by "consolidate", exactly? What you describe is the expected behavior when you use "Force Consolidate" - provided that everything else stays the same, and no data has been loaded or entered in the meantime between your two consolidate operations.

A "Force Consolidate" impacts all entities below the entity you force consolidate, hence, changing the calculation status for your alternate hierarchy. When you use a simple "Consolidate", it should not impact the calc status of the alternate hierarchy. If you consolidate using workflow process, make sure to check what the process step has been set to use (force or normal consolidate). 

If you were already aware of that and ran your tests as needed, there may also be e.g. a business rule impacting the status of entities even though you only use a normal consolidate. But that needs a deeper dive into the solution.

AndreaF's avatar
AndreaF
Contributor III
2 years ago

You are right, I was testing using the Force Consolidate, hence the problem. In any case I have created a Parent member of both hierarchies, so that other admin users can run the consolidation of that top member directly. In that case even using the Force consolidate they will not have any issue with the alternative hierarchy consolidation status.

  • Henning's avatar
    Henning
    Valued Contributor II
    2 years ago

    Happy that I was able to point you in the right direction!

    ( Adding this also for other partners / users who may be reading this at some point as a reminder: ) Please keep in mind the performance implications of consolidating this new top member that combines two alternate hierarchies. This (likely) duplicates the number of entities consolidated and a "force" consolidates entities even with an "OK" status, therefore taking (considerably) longer to consolidate. That may be ok in your case, but if someone with a large number of entities does that, this may not result in a consolidation time the users expect / need for their closing process.