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

Shared entity members and rules - rules only runs for primary member

in Financial Consolidation and Close 3 comments

We have a couple of rules in the main consol rules which should only run for certain entities. To do this we added an if statement for the entities for example, IF (@ISMBR(@Relative("PARENTA",0))).

Since then, an alternate hierarchy in the entity in the dimension has been created with a couple of the entities under PARENTA shared under the alternate hierarchy.

We found that when running the consolidation rules, the rules that are restricted by IF (@ISMBR(@Relative("PARENTA",0))) will only run for the entities under PARENTA and not the shared entities that sit under the alternate hierarchy (to be clear the primary member sits under PARENTA and is shared under the alternate hierarchy).

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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