CUBE DIMENSION - REPORTING CURRENCY

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.

ATTRIBUTES

Attribute Hierarchy Description
Reporting Currency NO Represents the CODE of the dimension, i.e. the reporting currency.

USED BY CUBE

Cube Name
GENERAL LEDGER
MAINTENENCE
MANUFACTURING
PROCUREMENT
PROJECT
SALES
SALES CONTRACT

ETL Information

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