OneStream Community

gkeushkerian · 04-22-2023

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 different math for those combinations. The issue i am fa...

gkeushkerian · 02-13-2023

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 i dont want the user to be changing this property e...

gkeushkerian · 03-23-2023

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 set Custom as Translation Algorithm Type in cube properties If api...

gkeushkerian · 02-17-2023

Hi Henning,Finally i could make it work with a FinanceFunctionType.Translate in a BR and a Custom Translation Algorithm Type in the Cube Properties.Thanks for the piece of code.

gkeushkerian · 02-14-2023

Hi Henning,Thanks for the reply. This is just what i was trying to achive. But i couldn't make it work. Tried with a FinanceFunctionType.FxRate and also FinanceFunctionType.Translate but couldnt get the values translated to the prior year rate.I fina...

gkeushkerian · 02-13-2023

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 tables just for period movements. Wanted to handle that thro...

OneStream Community

User Statistics

User Activity

Switch scenario, period and value members when looping data buffer cells

Custom Translation for FX Scenario - Help

Re: Custom Translation for FX Scenario - Help

Re: Custom Translation for FX Scenario - Help

Re: Custom Translation for FX Scenario - Help

Re: Custom Translation for FX Scenario - Help