Forum Discussion

Rutger's avatar
Rutger
New Contributor II
3 years ago

How to remove currency #EUR and keep #Local amount

Hi, We have a non-euro company that initially reported on input_level. That local amount has been translated to EUR. Later on in the process the local amount was removed, however the converted EUR ...
Consolidation
FX Rates
Rutger's avatar
Rutger
New Contributor II

Unfortunately not. This was in our second month "live" in onestream. As next month was OK we left it as it was. But it remains not clear.

MarkBird's avatar
MarkBird
Contributor III
2 years ago

Hi Rutger 

We've been facing a similar issue, we managed to resolve this by creating a simple custom calculate finance business rule to clear all translated data. See the steps below:

1) Setup 'ClearTranslatedData' business rule:

Namespace OneStream.BusinessRule.Finance.ClearTranslatedData
	Public Class MainClass
		Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As FinanceRulesApi, ByVal args As FinanceRulesArgs) As Object
			Try
				Select Case api.FunctionType

					Case Is = FinanceFunctionType.CustomCalculate
						api.Data.ClearCalculatedData("Cb#MY_CubeName", True, True, True, True)

				End Select

				Return Nothing
			Catch ex As Exception
				Throw ErrorHandler.LogWrite(si, New XFException(si, ex))
			End Try
		End Function
	End Class
End Namespace

2) Create a Data Management Job to execute the ClearTranslatedData business rule.

 
3) Configure you parameters as required.

 

Mark