Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Substitution variable "ProportionalizeTopEntityMembers" — Cloud Customer Connect
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"

Received Response
31
Views
2
Comments
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!