Unifier - Cash Flow / Primavera - Cash Flow
Description: Use this subject area to analyze WBS shell-level cash flows and commitment-level cash flows. You can map columns to predefined WBS shell-level cash flow curves and commitment level cash flow curves respectively. Ten generic columns are included to support cash flow curves.
| Folder | Subfolder | Field Name | Dimension/ Fact / Lookup | Description | Values Derived From / Calculated By |
|---|---|---|---|---|---|
| Commitment | Base Commit BP | Dimension | Base Commit BP | ||
| Commitment | Base Commit BP | Base Commit BP Name | Dimension | Base Commit BP Name |
Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_BASE_COMM_BP_NAME
|
| Commitment | Base Commit BP | Base Commit BP Record Name | Dimension | Base Commit BP Record Name |
Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_BASE_COMM_BP_REC_NAME
|
| Commitment | Base Commit BP | Base Commit BP Record Number | Dimension | Base Commit BP Record Number |
Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_BASE_COMM_BP_REC_NO
|
| Commitment | Change Commit BP | Change Commit BP | |||
| Commitment | Change Commit BP | Business Process Name | Dimension | Change Commit BP Name |
Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_SRC_BP_NAME
|
| Commitment | Change Commit BP | Record Id | Dimension | Change Commit BP Record Id |
Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_SRC_RECORDID
|
| Commitment | Change Commit BP | Record Name | Dimension | Change Commit BP Record Name |
Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_SRC_RECORD_NAME
|
| Commitment | Change Commit BP | Record Number | Dimension | Change Commit BP Record Number |
Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_SRC_RECORDNO
|
| Commitment | Change Commit BP | Status | Dimension | Change Commit BP Status |
Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_SRC_CC_BP_STATUS
|
| Commitment | Change Commit BP Line | Line Description | Dimension | Change Commit BP Line Description |
Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_SRC_LI_SHORT_DESC
|
| Commitment | Change Commit BP Line | Line Id | Dimension | Change Commit BP Line Id |
Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_SRC_LIID
|
| Commitment | Change Commit BP Line | Line Number | Dimension | Change Commit BP Line Number |
Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_SRC_LINUM
|
| Commitment | Dates - (Commitment) | Dates - (Commitment) | |||
| Commitment | Dates - (Commitment) | From Date | Dimension | From Date |
Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.FROM_DATE
|
| Commitment | Dates - (Commitment) | To Date | Dimension | To Date |
Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.TO_DATE
|
| Cash Flow Folder | |||||
| Cash Flow | Cash Flow | ||||
| Cash Flow | Cash Flow Name | Dimension | The name of the cash flow in project | Dim_W_CASH_FLOW_D_Cash_Flow.FAMILY_NAME | |
| Cash Flow | Unique Cash Flow ID | Dimension | The unique ID of the cash flow | Dim_W_CASH_FLOW_D_Cash_Flow.CF_OBJECT_ID | |
| Fact - Primavera - Cash Flow Folder | |||||
| Fact - Primavera - Cash Flow | Costs (Summary) | Fact | Costs (Summary) | ||
| Fact - Primavera - Cash Flow | 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"."Total (Base)", "P6Core"."Fact - Cash Flow"."Total (Project)")
|
| Fact - Primavera - Cash Flow | 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"."Unassigned Amount (Base)", "P6Core"."Fact - Cash Flow"."Unassigned Amount (Project)")
|
| Fact - Primavera - Cash Flow | 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"."Actuals (Base)", "P6Core"."Fact - Cash Flow"."Actuals (Project)")
|
| Fact - Primavera - 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
|
| Fact - Primavera - Cash Flow | 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"."Current Baseline (Base)", "P6Core"."Fact - Cash Flow"."Current Baseline (Project)")
|
| Fact - Primavera - Cash Flow | 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"."Forecast (Base)", "P6Core"."Fact - Cash Flow"."Forecast (Project)")
|
| Fact - Primavera - Cash Flow | 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"."Initial Baseline (Base)", "P6Core"."Fact - Cash Flow"."Initial Baseline (Project)")
|