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>' |