The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
OSAdmin
OneStream Employee
OneStream EmployeeAsking for a customer. Is is possible to apply currency translation on data in the Stage ?
Originally posted by Henri Roest
7/12/2018
Asking for a customer. Is is possible to apply currency translation on data in the Stage ?
OSAdminOneStream Employee
OneStream EmployeeI had to do this for my client.I'm using the FX rates stored in the cube and converting them to local currency.
I've a currency column in my plan table.
Dim entity As String = args.Line.Split(",")(4).Trim()
Dim currency As String = args.Line.Split(",")(7).Trim()
Dim entityID As Integer = BRApi.Finance.Members.GetMemberId(si, DimTypeId.Entity, entity)
Dim locCurrency As String = BRApi.Finance.Entity.GetLocalCurrency(si,entityID).Name
Dim wfTimeName As String = BRApi.Finance.Time.GetNameFromId(si,si.WorkflowClusterPk.TimeKey)
Dim fxRatePkUsingNames As New FxRatePkUsingNames("AverageRate", wfTimeName, currency, locCurrency)
If currency.XFEqualsIgnoreCase(locCurrency) Then
Return args.Value
Else
Return args.Value/BRApi.Finance.Data.GetStoredFxRate(si,fxRatePkUsingNames).Amount
End If
Value before conversion
after
Staging table and Cube will show the same data now.