Database Reference
In-Depth Information
The Add Business Intelligence wizard
The Add Business Intelligence wizard can be used to implement currency conversion
in a cube; you can find it under the Cube menu by clicking on the menu option
Add
Business Intelligence
and then, on the second step of the resulting wizard, selecting
the
Define Currency Conversion
option. This wizard leverages Analysis Services
features that are available in both Standard and Enterprise editions, such as MDX
Script calculations. We can achieve the same result without using the wizard, or we
can modify the objects and code produced by the wizard so they do what we want.
Concepts and prerequisites
Before using the wizard, we have to model our cube so that we have:
•
A
Currency
dimension:
° The
Type
property of the dimension must be set to Currency
° The
Type
property of one attribute for the dimension must be set
to
CurrencyName
° The
IsAggregatable
property must be set to
False
for the
key attribute
•
A
Time
dimension:
° The
Type
property of the dimension must be set to Time
° The
Type
properties of dimension attributes must be set
appropriately. For example, for an attribute representing a date it
must be set to Date
•
An
Exchange Rate
measure group containing:
° A regular dimension relationship with the Time dimension
° A regular dimension relationship with the Currency dimension
° The
Type
property of the measure group is set to
ExchangeRate
(this is optional, but it is a best practice)
•
One or more other measure groups containing measures to be converted and
which have:
° A regular dimension relationship with the Time dimension
° If the measures are stored in multiple currencies, a regular dimension
relationship with the Currency dimension
Search WWH ::
Custom Search