This cube dimension represents reporting currencies, i.e. currencies that measures supporting reporting currency can be recalculated to. There is no core IFS Applications dimension that supports thie cube dimension. The available currencies are taken from the currency rate table as per the company and rate type defined in the configuration table LookupReportingCurrencyRateType and a dimension is built in the ETL step based in this information.
All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Attribute | Hierarchy | Description |
Reporting Currency | NO | Represents the CODE of the dimension, i.e. the reporting currency. |
Cube Name |
GENERAL LEDGER |
MAINTENENCE |
MANUFACTURING |
PROCUREMENT |
PROJECT |
SALES |
SALES CONTRACT |
BI Access View | BI Component | Recommended Source Type |
N/A | ACCRDI | N/A |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | N/A | N/A |
T - DW | 2.1.099 Load Dw_DIM_REPORTING_CURRENCY.dtsx | Dw_DIM_REPORTING_CURRENCY |
L - DM | 3.1.099 Load Dw_DIM_REPORTING_CURRENCY.dtsx | Dm_DIM_REPORTING_CURRENCY |