Unifier - Cash Flow History / Primavera - Cash Flow History

Description: Use this subject area to analyze weekly historical cash flow facts and commitment level cash flow facts to better understand changes over time. Note that dimensional cash flow history is not supported.

Folder	Subfolder	Field Name	Dimension/ Fact / Lookup	Description	Values Derived From / Calculated By
Cash Flow				Cash Flow
Cash Flow		Cash Flow Detail Level	Dimension	Cash Flow Detail Level	case Dim_W_CASH_FLOW_D_Cash_Flow.DETAIL_LEVEL when 1 then 'CBS' when 2 then 'Summary CBS' when 3 then 'Commitment' else NULL end
Cash Flow		Cash Flow Name	Dimension	The name of the cash flow in project	Dim_W_CASH_FLOW_D_Cash_Flow.FAMILY_NAME

Fact - Primavera - Cash Flow History Folder
Fact - Primavera - Cash Flow History	Costs (Summary)
Fact - Primavera - Cash Flow History	Costs (Summary)	Total	Fact	Total	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cash Flow History"."Total (Base)", "P6Core"."Fact - Cash Flow History"."Total (Project)")
Fact - Primavera - Cash Flow History	Costs (Summary)	Unassigned Amount	Fact	Unassigned Amount	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cash Flow History"."Unassigned Amount (Base)", "P6Core"."Fact - Cash Flow History"."Unassigned Amount (Project)")
Fact - Primavera - Cash Flow History	Costs	Actuals	Fact	Actuals cost	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cash Flow History"."Actuals (Base)", "P6Core"."Fact - Cash Flow History"."Actuals (Project)")
Fact - Primavera - Cash Flow History	Cash Flow	Cash Flow Date	Dimension	Cash Flow Date	Dim_W_DAY_D_Cash_Flow_Date.DAY_DT
Fact - Primavera - Cash Flow History	Costs	Current Baseline	Fact	Current baseline cost	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cash Flow History"."Current Baseline (Base)", "P6Core"."Fact - Cash Flow History"."Current Baseline (Project)")
Fact - Primavera - Cash Flow History	Costs	Forecast	Fact	Forecasted cost	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cash Flow History"."Forecast (Base)", "P6Core"."Fact - Cash Flow History"."Forecast (Project)")
Fact - Primavera - Cash Flow History	Costs	Initial Baseline	Fact	Initial baseline cost	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cash Flow History"."Initial Baseline (Base)", "P6Core"."Fact - Cash Flow History"."Initial Baseline (Project)")

Unifier Links Folder
Unifier Links				Go to Unifier Links
Unifier Links		Link to Cash Flow Log	Lookup	The link to the cash flow log in Unifier	'<a target="_blank" href="' \|\| VALUEOF(NQ_SESSION."DW_UNIFIER_LINK_BASE_URL") \|\| VALUEOF("DW_UNIFIER_LINK_PROJECT_LIST_BASE_URL") \|\| CAST ("P6Core"."Dim - Project"."Project Object Id" AS VARCHAR ( 10 )) \|\| '&k=analyticscashflow">' \|\| 'Link to Cash Flow Log' \|\| '</a>'
Unifier Links		Link to Cost Sheet Log	Lookup	The link to the cost sheet log in Unifier	'<a target="_blank" href="' \|\| VALUEOF(NQ_SESSION."DW_UNIFIER_LINK_BASE_URL") \|\| VALUEOF("DW_UNIFIER_LINK_PROJECT_LIST_BASE_URL") \|\| CAST ("P6Core"."Dim - Project"."Project Object Id" AS VARCHAR ( 10 )) \|\| '&k=analyticscost">' \|\| 'Link to Cost Sheet Log' \|\| '</a>'
Unifier Links		Link to Project	Lookup	The link to the project landing page in Unifier	'<a target="_blank" href="' \|\| VALUEOF(NQ_SESSION."DW_UNIFIER_LINK_BASE_URL") \|\| VALUEOF("DW_UNIFIER_LINK_PROJECT_LIST_BASE_URL") \|\| CAST ("P6Core"."Dim - Project"."Project Object Id" AS VARCHAR ( 10 )) \|\| '&k=analyticsproject">' \|\| 'Link to Project' \|\| '</a>'

Related Topics