Custom allocation is taking longer

Summary

Custom allocation include a copy of data from a memeber formula account to another

Content

Hi All,

We have a requirement to take parent level entity for driver account and for that we created MDX formula account to fetch data from its corresponding legal entity. In detail, we have below entity structure where driver data has to be considered at Legal Entity1,2,3.. level:

Entity

|_Legal Entity1

|_Business Area11

|_Cost center111

|_Legal Entity2

|_Business Area21

|_Cost center211

|_Legal Entity3

|_Business Area31

|_Cost center311

Now, to achieve this  we created MDX formula account and tried using this as driver directly in Allocation rule or custom rule which didn't work. As a workaround, we created another account and created custom rule to push the MDX formula account data into this new account. This is working and giving us the accurate results but this custom rule is taking 10hrs to complete.