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...
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...
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 functional
currency Apply the following configuration for ...
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
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...
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...