In OBIEE how to convert the currency

Question

Hello ,

I have one revenue column and one related  to revenue currency column ,

but the problem is revenue contain multiple currency value (Eg:- AED, USD,EUR,INR)

but I want to convert all the currency in to USD format .

How i solve this issue , please help me

Thanks & Regards

Sandeep Andhale

AkanshAgarwal · Answer

Hi Sandeep,

The best way is to create a table with conversion rate and join the  fact table to this dimension.

Using conversion rate to convert your currency into USD.

Regards,

Akansh agarwal