Advanced Cube Design - Professional SQL Server Analysis Services 2005 with MDX - page 446

rencySource. Lastly, click the Source Currency Code attribute and
verify its Type property is CurrencyIsoCode. You can make sure you
get the property settings right by selecting Currency as the Dimen-
sion Type when using the Dimension Wizard to create the dimen-
sion. The wizard will prompt you for the column in your table contain-
ing the currency's ISO code and for the key attribute. Alternately you
can change the properties after the dimension is created.
5. Now you're ready to start the Business Intelligence Wizard. The wiz-
ard will create a second currency dimension, one used for reporting
the converted currencies, for you as well as updating the MDX script
with calculations that ensure the currency conversion is correctly ap-
plied to affected measures. Right-click the Adventure Works cube in
Solution Explorer, click Add Business Intelligence, click Next, click
Define Currency Conversion, and then click Next.
6. In the Set Currency Conversions Options dialog the wizard looks for
measure groups of type ExchangeRate and pre-selects that measure
group. If such a measure group does not exist then it selects the first
measure group. Click Exchange Rates in the "Select the measure
group that contains exchange rates" list. In the "Specify the pivot cur-
rency" list box, click USD, and then click OK. Lastly, click the N USD
Per 1 ARS radio button, as shown in Figure 9-52 . The FactCur-
rencyRate table, on which the Exchange Rate measure group is
based, has rates to convert one unit of local currency (such as one
Australian dollar) into a standard currency (US dollars in this case),
which is called a pivot currency. If the table contained rates to con-
vert 1 unit of the pivot currency into the local currency, you would se-
lect the N ARS Per 1 USD radio button. The drop down list contains
a pre-defined list of currencies to help you make the right selection.
Click Next to continue.