Fact - Project Transactions

This cube fact represents project transaction information and is based on the IFS Applications fact FACT_PROJECT_TRANSACTIONS. This is a fact from HR.

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

USED BY CUBE

Cube Name Product Area
Project Project Based

ETL Information

BI Access View BI Component Recommended Access Type
FACT_PROJECT_TRANSACTIONS_BI PRJRFT On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.2.038 Load IFSAppl_FACT_PROJECT_TRANSACTIONS_BI.dtsx IFSAppl_FACT_PROJECT_TRANSACTIONS_BI
T - DW 2.2.038 Load Dw_FACT_PROJECT_TRANSACTIONS.dtsx Dw_FACT_PROJECT_TRANSACTIONS
L - DM 3.2.038 Load Dm_FACT_PROJECT_TRANSACTIONS.dtsx Dm_FACT_PROJECT_TRANSACTIONS

 

SPECIAL INFO

This fact supports Reporting Period, i.e. a dimension that can be used to when doing cross product/module reporting. Attributes chosed to connect the fact with the dimension is company and the date account_date.This fact consists of amounts calculated to reporting currency. The data used to find the rates is account_date (representing DIM_ACCOUNT_DATE)