Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Substitution variable "ProportionalizeTopEntityMembers"

edited Feb 16, 2021 2:40PM in Financial Consolidation and Close 2 comments

Content

Within the Entity dimension we have a secondary hierarchy (outside of "Total Geography") which consists of shared members retrieved from the primary hierarchy. While the primary it's used by Accounting, the secondary is used by Controlling for management reporting.

The "Consolidation enhancements" introduced by the 21.12 update (see image) had for us the consequence that the parent member of the secondary hierarchy would not aggregate the values of it's children anymore. It's treated now as a label and thus we currently have values for the children, but they are not consolidated at parent level.

To overcome this we applied the "ProportionalizeTopEntityMembers" substitution variable. We applied it to "Consol" and set it to True.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!