Forum Discussion

AndraEcxarcu's avatar
AndraEcxarcu
New Contributor II
2 years ago

FX rates retrieval – based on different source currencies

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...
Finance
AndraEcxarcu's avatar
AndraEcxarcu
New Contributor II
2 years ago

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 be api.Entity.GetLocalCurrencyId:

Dim sourceCurrId As Integer = api.Entity.GetLocalCurrencyId

This works exactly as I need.

Have a great day!