Forum Discussion

gkeushkerian's avatar
gkeushkerian
New Contributor II
2 years ago

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 ...
Finance
  • Henning's avatar
    Henning
    2 years ago

    In your case, all you need may just be this (have not tested it) in a Finance BR attached to the cube. Provided that you add some limitations to ensure this executes for the correct scenario only and still execute the default translation for your standard scenarios.

     

     

    Dim BudScenarioId As Integer = api.Members.GetMemberId(dimTypeId.Scenario, "BUD")
Dim priorTimeId As Integer = api.Time.GetPriorYearPeriodId(api.Pov.Time.MemberPk.MemberId)

Dim RateTypeCloBudPre As FxRateType = api.FxRates.GetFxRateTypeForAssetLiability(,BudScenarioId) 
Dim cloRateBudPre As Decimal =  api.FxRates.GetCalculatedFxRate(RateTypeCloBudPre,priorTimeId)
Dim RateTypeAvgBudPre As FxRateType = api.FxRates.GetFxRateTypeForRevenueExp(,BudScenarioId)
Dim avgRateBudPre As Decimal =  api.FxRates.GetCalculatedFxRate(RateTypeAvgBudPre,priorTimeId)

api.ExecuteDefaultTranslation(FxRuleType.Direct, avgRateBudPre, FxRuleType.Direct, cloRateBudPre)

     

     

    (Using S#BUD and prior year period as an example source for the FX rate) 

gkeushkerian's avatar
gkeushkerian
New Contributor II

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.

 

Krishna's avatar
Krishna
Valued Contributor
2 years ago

Hi - Could you please the snippet just the api.data.transalate line ? also did you change the Cube Properties to custom translate ? and attached the BR in the rule section. 

 

Thanks

  • gkeushkerian's avatar
    gkeushkerian
    New Contributor II
    2 years ago

    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.Pov.Scenario.Name = "ActualAtPYRate" Then 

							Dim ActualScenarioId As Integer = api.Members.GetMemberId(dimTypeId.Scenario, "Actual")
							Dim priorTimeId As Integer = api.Time.GetPriorYearPeriodId(api.Pov.Time.MemberPk.MemberId)

							Dim RateTypeCloActPre As FxRateType = api.FxRates.GetFxRateTypeForAssetLiability(,ActualScenarioId) 
							Dim cloRateActPre As Decimal =  api.FxRates.GetCalculatedFxRate(RateTypeCloActPre,priorTimeId)
							Dim RateTypeAvgActPre As FxRateType = api.FxRates.GetFxRateTypeForRevenueExp(,ActualScenarioId)
							Dim avgRateActPre As Decimal =  api.FxRates.GetCalculatedFxRate(RateTypeAvgActPre,priorTimeId)

							api.ExecuteDefaultTranslation(FxRuleType.Periodic, avgRateActPre, FxRuleType.Direct, cloRateActPre)
						
						Else
							api.ExecuteDefaultTranslation()
						End If
				End Select

     

     

    • Krishna's avatar
      Krishna
      Valued Contributor
      2 years ago

      Thanks for the response. Appreciate your help.