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.
Cube Name | Product Area |
Project | Project Based |
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 |
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)