No Currency Conversion

Reporting in multiple currency types should not be construed as currency conversion. In Transactional Business Intelligence, Fact amounts are never converted from one currency to other currencies. Fact amounts are simply aggregated by currency codes along with other dimensions involved in the report. If a Fact supports multiple currency types reporting, then the Fact contains one amount column (or only one amount column for all currency types) and one currency column (or only one currency column for all currency types) for each currency type that it supports. The correct logical column for the amount metric and currency code are selected, during run time, depending on the preferred currency type set in the user preferences screen. In Transactional Business Intelligence reporting, if an amount metric is added into the report, select the currency code column from the Fact degenerate Dimension (usually contains the word details and comes after the Fact folder).