Skip to main content
C
CLU
November 1, 2024

Turn off Translation - Budget Scenario for Specific Entities or Account

  • November 1, 2024
  • 1 reply
  • 0 views

Looking into a way to turn off translation for specific entities, yet only for the budget scenario and select gain/loss accounts. Having translation on for Other Expense and Net Income as it relates to budgeting is skewing the EBIT bottom line. Is turning translation on a budget scenario and specific Entities possible? 

Thanks in advance, 

1 reply

B
BobNelson
November 5, 2024

In the cube settings you can use a translation algorithm type of "Standard Using Business Rules for FX Rates". 

BobNelson_0-1730836110454.png

Once this is set, you can write a Finance Business Rule and add it to the cube settings.  I don't have any non-client code samples available to post publicly, but examples of what I have used (or seen used) are to set FX rate for a currency, such as VEB, to 1, or to set FX rate for a specific scenario to 1.  Another example is to combine FX rates for a forecast scenario, such as copy actual for Jan to Mar, then copy Budget for April through December.  

You can also set rates in a specific scenario for a specific account type (income/expense) to 1 while leaving the other account type (asset/liability) alone.

If you need to get more granular, then the setting on the cube is Custom for translation algorithm.  Here you can set rates or translation methods for specific accounts, such as cashflow type accounts use a YTD average for changes in account balances instead of monthly averages.

Hope this explanation helps.

 

Terms & ConditionsAccessibility statement