In OBIEE how to convert the currency — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

In OBIEE how to convert the currency

Received Response
1
Views
1
Comments
Sandeep Andhale
Sandeep Andhale Rank 3 - Community Apprentice
edited Aug 13, 2024 7:09PM in Oracle Analytics Cloud and Server

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

Answers

  • AkanshAgarwal
    AkanshAgarwal Rank 4 - Community Specialist

    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