Forum Discussion

ajslack's avatar
ajslack
New Contributor II
8 months ago

C#Aggregated and Custom Translation Rule

I am looking to create a FX Rate finance rule or calculate to go get the planning scenario's last actual month's closing rate from the ClosingRate FX table. I am using the consolidation member C#Aggregated in the planning scenarios. 

I know that C#Aggregated executes business rules at the base level only.

Is there a workaround here or if I use C#Aggregated am I stuck creating FX rate tables for each planning scenario and copying last actual month rates forward to the planning periods?

Appreciate any help or guidance. 

Thanks 

Admin
Finance
Parsing
XFBR
  • Henning's avatar
    Henning
    Valued Contributor II
    8 months ago

    Hi, no, I do not see a feasible way other than creating dedicated FX tables which you seed with the needed FX rates as needed for the scenarios you use C#Aggregated for.

    One could do this as part of the calculation of the aggregated data on C#Local, seeding the FX rates, storing a boolean in a global to ensure this is only done once per execution. But then I do not see that this is so much better than just doing this outside of the Aggregation as this would only need to be done once and not for each time someone aggregates the data.