Adding Currency Conversion - Expert Cube Development with SSAS Multidimensional Models - page 182

How to use the Add Business Intelligence
wizard
We will demonstrate the use of the wizard in three main scenarios. As we will see, the
key decision you have to make in using the wizard comes on the third step, the Select
Conversion Type page. Some of what the wizard generates is the same regardless of
which option you choose and we will discuss these parts in the first scenario, and then
we will comment only on what is different for the remaining scenarios.
Data collected in a single currency with reporting in
multiple currencies
The first scenario we consider is probably the most common, where we have
data collected using a single currency, and the same currency is used as the Pivot
Currency. We will use a simple model to show the steps of the wizard. This model
has a transaction fact table with two dimensions (Product and Date) and a currency
exchange rate fact table with two dimensions (Date and Currency), as seen in the
following screenshot. The Pivot Currency in the Rate measure group and the Local
Currency in the transaction measure group are US dollars.