Skip to main content
O
Oscar
March 19, 2024
Solved

Best Approach

  • March 19, 2024
  • 1 reply
  • 0 views

We use Standard (Calc On The Fly Share and Hierarchy Elimination). 

What type of Rule should we leverage to reclass balances from one account to another during consolidation. For illustration purposes, the below is what we are looking at:


Oscar_0-1710857336945.png

 

Best answer by JackLacava

I'm not sure I understand the question, sorry.

You can do anything you want in consolidation rules. If you mean you have some data that needs to be moved from one Entity to the other (i.e. so it won't be consolidated on the source entity), you should load it against a dummy UD then copy it where it needs to go.

1 reply

J
JackLacavaAnswer
March 20, 2024

I'm not sure I understand the question, sorry.

You can do anything you want in consolidation rules. If you mean you have some data that needs to be moved from one Entity to the other (i.e. so it won't be consolidated on the source entity), you should load it against a dummy UD then copy it where it needs to go.

O
OscarAuthor
March 20, 2024

hi Jack

Because we are running the standard consolidation (no business rule associated with the cube) I am wondering if a Member Formula is more appropriate for this reclass. Perhaps embed the rule in Account1 but then the question is the formula would be executed multiple times during consolidation 

J
JackLacava
March 20, 2024

Generally speaking, for pure consolidation, member formulas do indeed fit better on individual members; and pulling data is better than pushing.

In this case, I would probably put the formula on U4#ReclassThis. It will only execute for that UD once per entity, and you can target multiple accounts from there if necessary.

Terms & ConditionsAccessibility statement