Export (0) Print
Expand All
Expand Minimize

Select Conversion Type (Business Intelligence Wizard) (SSAS)

Use the Select Conversion Type page to define the relationship between local currencies and reporting currencies for transactions stored in multiple currencies. A local currency is the currency in which the transactions for measures selected in the Select Measures page are stored. A reporting currency is the currency in which the transactions selected in the Select Measures page are translated.

ms178672.note(en-US,SQL.90).gifNote:
This page does not appear if the Business Intelligence Wizard was started from Dimension Designer or by right-clicking a dimension in Solution Explorer in Business Intelligence Development Studio.

Many-to-many

Stores transactions using local currencies. The currency conversion functionality converts such transactions into the pivot currency specified in the Set Currency Conversion Options page, and then to one or more other reporting currencies.

For example, the pivot currency can be set to United States dollars (USD), and the fact table stores transactions in euros (EUR), Australian dollars (AUD), and Mexican pesos (MXN). Selecting this option converts these transactions from their specified local currencies to the pivot currency, and then the converted transactions are converted again from the pivot currency to the specified reporting currencies. The result is that transactions can be stored in the specified local currencies and viewed either in the specified pivot currency or in any one of the reporting currencies specified in the Specify Reporting Currencies page.

Many-to-one

Stores transactions using local currencies. The currency conversion functionality converts such transactions into the pivot currency specified in the Set Currency Conversion Options page. The pivot currency serves as the only specified reporting currency.

ms178672.note(en-US,SQL.90).gifNote:
If this option is selected, the Specify Reporting Currencies page does not appear.

For example, the pivot currency can be set to United States dollars (USD), and the fact table stores transactions in euros (EUR), Australian dollars (AUD), and Mexican pesos (MXN). Selecting this option converts these transactions from their specified local currencies to the pivot currency. The result is that transactions can be stored in the specified local currencies and viewed in the specified pivot currency.

One-to-many

Store transactions using the pivot currency specified in the Set Currency Conversion Options page, and then to one or more other reporting currencies.

ms178672.note(en-US,SQL.90).gifNote:
If this option is selected, the Define Local Currency Reference page does not appear.

For example, the pivot currency can be set to United States dollars (USD), and the fact table stores transactions in USD. Selecting this option converts these transactions from the pivot currency to the specified reporting currencies. The result is that transactions can be stored in the specified pivot currency and viewed either in the specified pivot currency or in any one of the reporting currencies specified in the Specify Reporting Currencies page.

Community Additions

ADD
Show:
© 2014 Microsoft