Cash Flow Summary Dashboard

Description: The Cash Flow Summary dashboard provides users to see how the initial baseline compares to current baseline, actuals, and forecasts on a year to year basis.

Number of Canvases: 2

Default Canvas: Currency Type - Base

Canvas/Dashboard Name: Cash Flow Summary

Data Source(s): Unifier

Subject Area: not applicable

Datasets: Cash Flow Dataset – Base, Cash Flow Dataset – Project

Canvases

Figure 5-1 Cash Flow Summary - Currency Type - Base


Cash Flow Summary - Currency Type - Base

Figure 5-2 Cash Flow Summary - Currency Type - Project


Cash Flow Summary - Currency Type - Project

Table 45: Cash Flow - Dimensions

Canvas Dimension / Attribute Subject Area / Dataset
Currency Type - Base Month Name Cash Flow Dataset – Base
Currency Type - Base Year Name Cash Flow Dataset – Base
Currency Type – Project Month Name Cash Flow Dataset – Project
Currency Type – Project Year Name Cash Flow Dataset – Project

Table 46: Cash Flow - Measures

Canvas Fact / Measure Measure Type Subject Area / Dataset
Currency Type - Base Initial Baseline (cum.) Calculated from Fact Cash Flow Dataset – Base
Currency Type - Base Current Baseline (cum.) Calculated from Fact Cash Flow Dataset – Base
Currency Type - Base Actuals (cum.) Calculated from Fact Cash Flow Dataset – Base
Currency Type - Base Forecast (cum.) Calculated from Fact Cash Flow Dataset – Base
Currency Type - Base Initial Baseline Fact Cash Flow Dataset – Base
Currency Type - Base Current Baseline Fact Cash Flow Dataset – Base
Currency Type - Base Actuals Fact Cash Flow Dataset – Base
Currency Type - Base Forecast Fact Cash Flow Dataset – Base
Currency Type - Base Initial Baseline [cum.] Calculated from Fact Cash Flow Dataset – Project
Currency Type - Base Current Baseline [cum.] Calculated from Fact Cash Flow Dataset – Project
Currency Type - Base Actuals [cum.] Calculated from Fact Cash Flow Dataset – Project
Currency Type - Base Forecast [cum.] Calculated from Fact Cash Flow Dataset – Project
Currency Type - Base Initial Baseline Fact Cash Flow Dataset – Project
Currency Type - Base Current Baseline Fact Cash Flow Dataset – Project
Currency Type - Base Actuals Fact Cash Flow Dataset – Project
Currency Type - Base Forecast Fact Cash Flow Dataset – Project

Table 47: Cash Flow - Calculated Members

Calculated Member Expression Source Subject Area / Dataset (s)
Initial Baseline (cum.)

RSUM(XSA('demouser'.'Cash Flow Dataset - Base')."Columns"."Initial Baseline")

 

 Derived From Fact Cash Flow Dataset – Base
Current Baseline (cum.)

RSUM(XSA('demouser'.'Cash Flow Dataset - Base')."Columns"."Current Baseline")

 

 Derived From Fact Cash Flow Dataset – Base
Actuals (cum.)

CASE WHEN TIMESTAMPDIFF(SQL_TSI_MONTH,XSA('demouser'.'Cash Flow Dataset - Base')."Columns"."Calendar Date",MAX(MAX(CASE WHEN XSA('demouser'.'Cash Flow Dataset - Base')."Columns"."Actuals" > 0 THEN XSA('demouser'.'Cash Flow Dataset - Base')."Columns"."Calendar Date" ELSE NULL END BY XSA('demouser'.'Cash Flow Dataset - Base')."Columns"."Datasource Id") BY 1)) >= 0 THEN RSUM(XSA('demouser'.'Cash Flow Dataset - Base')."Columns"."Actuals") ELSE NULL END

 

 Derived From Fact Cash Flow Dataset – Base
Forecast (cum.)

CASE WHEN TIMESTAMPDIFF(SQL_TSI_MONTH,XSA('demouser'.'Cash Flow Dataset - Base')."Columns"."Calendar Date",MAX(MAX(CASE WHEN XSA('demouser'.'Cash Flow Dataset - Base')."Columns"."Actuals" > 0 THEN XSA('demouser'.'Cash Flow Dataset - Base')."Columns"."Calendar Date" ELSE NULL END BY 1) BY 1)) < 1 THEN RSUM(XSA('demouser'.'Cash Flow Dataset - Base')."Columns"."Forecast") ELSE NULL END

 

 Derived From Fact Cash Flow Dataset – Base
Initial Baseline [cum.]

RSUM(XSA('demouser'.'Cash Flow Dataset')."Columns"."Initial Baseline")

 

 Derived From Fact Cash Flow Dataset – Base
Current Baseline [cum.]

RSUM(XSA('demouser'.'Cash Flow Dataset')."Columns"."Current Baseline")

 

 Derived From Fact Cash Flow Dataset – Base
Actuals [cum.]

CASE WHEN TIMESTAMPDIFF(SQL_TSI_MONTH,XSA('demouser'.'Cash Flow Dataset')."Columns"."Calendar Date",MAX(MAX(CASE WHEN XSA('demouser'.'Cash Flow Dataset')."Columns"."Actuals" > 0 THEN XSA('demouser'.'Cash Flow Dataset')."Columns"."Calendar Date" ELSE NULL END BY XSA('demouser'.'Cash Flow Dataset')."Columns"."Datasource Id") BY 1)) >= 0 THEN RSUM(XSA('demouser'.'Cash Flow Dataset')."Columns"."Actuals") ELSE NULL END

 

 Derived From Fact Cash Flow Dataset – Base
Forecast [cum.]

CASE WHEN TIMESTAMPDIFF(SQL_TSI_MONTH,XSA('demouser'.'Cash Flow Dataset')."Columns"."Calendar Date",MAX(MAX(CASE WHEN XSA('demouser'.'Cash Flow Dataset')."Columns"."Actuals" > 0 THEN XSA('demouser'.'Cash Flow Dataset')."Columns"."Calendar Date" ELSE NULL END BY 1) BY 1)) < 1 THEN RSUM(XSA('demouser'.'Cash Flow Dataset')."Columns"."Forecast") ELSE NULL END

 

 Derived From Fact Cash Flow Dataset – Base