FACT -  INVENT TRANS HIST

This cube fact represents inventory transaction history information and is based on the IFS Applications fact FACT_INVENT_TRANS_HIST.

Note: Please refer to documentation of each cube to find out about attributes used in referenced cubes.

USED BY CUBE

Cube Name Product Area
Inventory Supply Chain

ETL Information

BI Access View BI Component Recommended
Source Type
FACT_INVENT_TRANS_HIST_BI INVEFT On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.2.027 Load IFSAppl_FACT_INVENT_TRANS_HIST_BI.dtsx IFSAppl_FACT_INVENT_TRANS_HIST_BI
T - DW 2.2.027 Load Dw_FACT_INVENT_TRANS_HIST.dtsx Dw_FACT_INVENT_TRANS_HIST
L - DM 3.2.027 Load Dm_FACT_INVENT_TRANS_HIST.dtsx Dm_FACT_INVENT_TRANS_HIST

SPECIAL INFO

This fact supports Reporting Date, i.e. a time dimension that can be used to when doing cross product/module reporting. The date chosen to connect the fact with the dimension is date_created, date_applied and expiration_date. This date is also used when finding the currency rate for calculation of reporting currency amounts.