Create a Currency type Dimension
In Microsoft SQL Server Analysis Services, a currency type dimension is a dimension whose attributes represent a list of currencies for financial reporting purposes.
A currency dimension lets you add currency conversion capabilities to a cube in Analysis Services. To add currency conversion to a cube, you use the Business Intelligence Wizard define a Multidimensional Expressions (MDX) script command that converts currency measures to values that are appropriate for the locale of the client application. To create this MDX script, the Business Intelligence Wizard needs the following information:
A currency dimension that represents source currencies. (This dimension is the source currency dimension.)
A measure group that represents the exchange rates that will be used.
From this information, the Business Intelligence Wizard will design a currency conversion process that identifies the appropriate destination currency dimension (the currency dimension that represents destination currencies). Depending on the number of currency conversions that your business intelligence solution requires, the Business Intelligence Wizard can define multiple destination currency dimensions. For more information about defining currency conversions, see Currency Conversions (Analysis Services - Multidimensional Data).
To identify a dimension as a currency dimension, set the Type property of the dimension to Currency.
A currency dimension contains, at least, a key attribute identifying individual currencies in the dimension table for the currency dimension. The value of the key attribute is different in both source and destination currency dimensions:
To identify an attribute as the key attribute of a source currency dimension, set the Type property of the attribute to CurrencySource.
To identify an attribute as the destination currency dimension, set the Type property of the attribute to CurrencyDestination.
For reporting purposes, both source and destination currency dimensions can optionally contain the following attributes:
A currency name attribute.
To identify an attribute as a currency name attribute, set the Type property of the attribute to CurrencyName.
A currency source attribute.
To identify an attribute as a currency source attribute, set the Type property of the attribute to CurrencySource.
A currency International Standards Organization (ISO) code.
To identify an attribute as a currency ISO code attribute, set the Type property of the attribute to CurrencyIsoCode.
For more information about attribute types, see Configure Attribute Types.
After you have defined an account dimension and added that dimension to a cube, you can use the Business Intelligence Wizard to add account intelligence functionality, such as identifying and mapping account types, to the dimension. For more information, see Add Account Intelligence to a Dimension.