Databases Reference
In-Depth Information
Figure 9-56
11. Click Next, and then click Cancel on the final page of the wizard. Be-
cause the Destination Currency and currency conversion calcula-
tions are already in the cube, the wizard doesn't need to do anything.
But if you are adding this capability to your own cube, there's still
more to explore to better understand what the wizard would do if you
started the process with only a Source Currency dimension and an
Exchange Rates fact table.
12. Double-click the Adventure Works data source view in Solution Ex-
plorer. In the Tables pane, right-click DimDestinationCurrency, and
then click Edit Named Query. A query similar to the following query
would be created by the Business Intelligence Wizard when creating
a reporting currency. The WHERE clause of this query would detail
currencies selected on the Specify Reporting Currencies page of the
wizard (see
Figure 9-56
) if you picked some, but not all, available
currencies. Notice that the main foundation for the named query is
the DimCurrency table which is also used for the Source Currency
dimension in the Adventure Works DW database.
SELECT CurrencyKey, CurrencyAlternateKey,
CurrencyName
Search WWH ::
Custom Search