Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Trying to understand Currency conversion Expand / Collapse
Posted Wednesday, May 21, 2008 8:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 27, 2010 4:12 AM
Points: 2, Visits: 27

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.


Girija Shankar

Post #504546
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse