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

Custom allocation is taking longer

Received Response
edited Mar 12, 2020 9:00AM in Profitability and Cost Management 2 comments


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


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:

|_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.

Howdy, Stranger!

Log In

To view full details, sign in.


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