SAC Data Action - Allocation based on multiple dimensions

[hi2guru]

Hi Friends,

I have a requirement to allocate the budget data against Costcentre and G/L account. Driver being the previous year Actuals.

I have the data to be allocated saved in a Datasource (Highlevel phasing) against a default costcentre for multiple G/L accounts. This data is copied from another model.

I saved the yearly Actuals under the same version. Actuals will be having the costcentres that doesnot have the default costcentre.

Allocation of budget data should happen from the default costcentre to the other costcentres against corresponding G/L accounts. Allocation driver being Average amount of costcentre for past 2 or 3 years.

Sample data is like below

I couldn't try Allocate step as my planning model has Account as generic.

I tried the advanced formula like below with nested ForEach (one for Costcentre and another for Account), but it takes very long (around 20 minutes ) to execute and fail. Code other than the declaration is as below(Only for previous year).

Can I please get help to understand if I am doing anything wrong or if there is a better way to handle this.

Any help would be much appreciated. @N1kh1l Thanks.