Databases Reference
In-Depth Information
FROM DimCurrency
WHERE (CurrencyKey IN
(SELECT DISTINCT
CurrencyKey
FROM
FactCurrencyRate))
13. Switch to the Cube Designer, click the Dimension Usage tab, and
locate the relationships between the Exchange Rate measure group
and other dimensions. Only the Date and Destination Currency di-
mensions have a regular relationship with Exchange Rate. Recall
that you learned about many-to-many relationships earlier in this
chapter. In the current example, Internet Sales has sales amounts in
many local currencies which need to be converted — by way of Ex-
change Rates — to multiple destination currencies. Accordingly, In-
ternet Sales has a regular relationship with Source Currency (repres-
enting the local currency) and a many-to-many relationship with
Destination Currency with Exchange Rate as the intermediate meas-
ure group.
A simple Analysis Services project based on the AdventureWorksDW rela-
tional database, along with instructions to use the currency conversion wizard
and verify the results, are available at the download site for this topic.
Search WWH ::
Custom Search