Trying to understand Currency conversion

• girija45701-752238

  Valued Member

  Points: 64

  More actions

  May 21, 2008 at 8:56 am

  #190877

  I am trying to understand the currency conversion but facing some problems in the same.The more I am tring to understand that the more confused am i getting.

  My requirement is specific. I am trying to write sql queries for the measures which come under the scope of currency conversion.

  I will query the Cube to get the measure value :

  SELECT [Measures].[Sales Amount] on 0 from [Adventure Works DW]

  And then query the SQL database as:

  Use AdentureWorksDW

  SELECT SUM(SalesAmount) FROM FactInternetSales

  My understanding is this ( Please correct me if i am wrong) :

  If the Currency conversion is:

  1. Many to One : Data will be different (in SQL and MDX) as currency conversion is applied which will convert that to a particular (Corporate) currency.

  2. One To many : Data will not be different (in SQL and MDX)

  2. Many to many : Data will not be different (in SQL and MDX)

  I did not get much information on the same from anywhere. I want to undersatnd the script of the Currency conversion. (The script generated by Currency conversion wizard) and then depending on the script (I will extract the Type of conversion) write the SQL for that.

  Regards..

  Girija Shankar