User Profile

gkeushkerian

New Contributor II

Joined 4 years ago

8 Posts6 Likes1 Solution

View All Badges

User Widgets

Contributions

Re: 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...
2 years ago Place Application Build
1.4KViews
3likes
1Comment
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 ...
Solved
3 years ago Place Rules
Finance
7.3KViews
0likes
10Comments
Switch 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...
Solved
3 years ago Place Rules
Finance
2KViews
0likes
2Comments
Re: 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 ...
3 years ago Place Rules
6.5KViews
2likes
1Comment
Re: Custom Translation for FX Scenario - Help
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.
3 years ago Place Rules
7KViews
1like
3Comments
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 a FinanceFunctionType.FxRate and also FinanceFunctionType.Translate but couldnt ge...
3 years ago Place Rules
7KViews
0likes
0Comments
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...
3 years ago Place Rules
7.1KViews
0likes
0Comments

Groups

No places to display