Currency management on SAP BO Cloud

[Former Member]

Hello everyone.

I am trying to create a model with data imported from SAP Business ByDesign and on the ERP, I have (at least) more than five different currencies for earch measure, and since currency conversion is disabled for models based on OData (Link here) I was wondering how I would have my measures all in one and unique currency.

For example, in the picture above, I have my net value formatted (amount and currency), then the net value (of Measure type) and the third column is the currency code.

Any idea how I can manage currencies in order to have all my data converted to one specific currency ?

[JohnL · Accepted solution]

Hello Nadia

Sorry for the delay. Have you tried enabling currency conversion in the acquired data model?

Also if the values are already converted did you make currency a dimension? That way you can restrict or see each converted currency. Be careful though because the aggragated currency values won't make sense so you need to make sure you always have currency in a story, page (input control), or group (builder tab) filter.

Let me know what you came up with.

HTH