FACT - GL PROJECT BALANCE

This cube fact represents project balances in General Ledger in Financials and is based on the IFS Applcations fact FACT_GL_PROJECT_BALANCE.

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

USED BY CUBE

Cube Name Product Area
General Ledger Financials

ETL Information

BI Access View BI Component Recommended
Source Type
FACT_GL_PROJECT_BALANCE_BI_OPT GENLFT On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.2.014 Load IFSAppl_FACT_GL_PROJECT_BALANCE_BI_OPT.dtsx IFSAppl_FACT_GL_PROJECT_BALANCE_BI_OPT
T - DW 2.2.014 Load Dw_FACT_GL_PROJECT_BALANCE.dtsx Dw_FACT_GL_PROJECT_BALANCE
L - DM 3.2.014 Load Dm_FACT_GL_PROJECT_BALANCE.dtsx Dm_FACT_GL_PROJECT_BALANCE

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 the start date of the accounting period for a balance. This date is also used when finding the currency rate for calculation of reporting currency amounts.