ContributionsMost RecentMost LikesSolutionsRe: Loading in USD and Translating to Local You can use Alternate Input currency OOB functionality. Create two members in the Flow dimension: Input_USD: used to input data in USD LC_USD: used to translated from USD into Entity assigned...Custom Translation for FX Scenario - Help Hello, I am trying to create a FX Scenario - Acutuals at Prior Year Rate. I know i can use Constant Year For FX Rate and assign the year from which OneStream will pick Actuals rate in this case. But ...SolvedSwitch scenario, period and value members when looping data buffer cells Hi. I am trying to forecast OpEx accounts based on a seeding method. I am storing the method on a specific month by account and some UD dimensions and based on the selected method want to apply diffe...SolvedRe: Custom Translation for FX Scenario - Help Hi Chris, Here goes the code. You need to set Custom to the Translation Algorithm Type in Cube Properties. Case Is = FinanceFunctionType.Translate 'Assign BR to Mgmt Reporting cube and ...Re: Custom Translation for FX Scenario - Help Hi Henning, Finally i could make it work with aFinanceFunctionType.Translate in a BR and a Custom Translation Algorithm Type in the Cube Properties. Thanks for the piece of code. Re: Custom Translation for FX Scenario - Help Hi Henning, Thanks for the reply. This is just what i was trying to achive. But i couldn't make it work. Tried with aFinanceFunctionType.FxRate and alsoFinanceFunctionType.Translate but couldnt ge...Re: Custom Translation for FX Scenario - Help Hi Hweeli for your reply. I have developed some rules to copy rates from one period to the other, even from one rate table to another one. I was trying to avoid creating several exchange rate table...