OneStream Community

AndraEcxarcu · 09-12-2023

Hi everyone! I have two entity hierarchies, one in currency EUR, and one in USD. I need to create a cube view to retrieve the FX rates based on the parent’s currency. I’ve created an account, for example ClosingRate, as a DynamicCalc. I am using this...

AndraEcxarcu · 09-06-2023

Hello everyone!I’m trying to set up an Excel spreadsheet to be used in a dashboard, for users to be able to insert their FX rates in the Workflow.I’m using the XFSetFxRate formula, and it works when I hard code the time, for example ‘2020M1’. However...

AndraEcxarcu · 09-21-2023

Thank you everyone for the help!@Big_Rick_CPM yes, I had to change my cube view. However, it would not have been helpful to display parent/child. Instead, I decided to use as entity only the parent, thus changing in my script the source currency to b...

AndraEcxarcu · 09-12-2023

This is the script from the member formula: Dim destCurrId As Integer = api.Pov.Cons.MemberPk.MemberId If destCurrId = Currency.EUR.Id Then Return 1.0 Else Dim rateType As FxRateType = api.FxRates.GetFxRateTypeForRevenueExp() Dim cubeId As Integer = ...

AndraEcxarcu · 09-12-2023

Hi @NicolasArgente Thanks for your reply! Unfortunately, it doesn't work. It brings the value 1 for all currencies  Do you think there is any other option for this to work in a cube view?

AndraEcxarcu · 09-06-2023

Hi @NicolasArgente !Thank you for the reply. Yes, this is one solution, initially I didn't want the user to have to select anything in terms of time  But if there is no other workaround, I guess I'll have to do it this way. Thanks!

OneStream Community

User Statistics

User Activity

FX rates retrieval – based on different source currencies

Load FX rates through spreadsheet – Workflow time needed

Re: FX rates retrieval – based on different source currencies

Re: FX rates retrieval – based on different source currencies

Re: FX rates retrieval – based on different source currencies

Re: Load FX rates through spreadsheet – Workflow time needed