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 32: Cash Flow Summary - Currency Type - Base

Cash Flow Summary-Currency Type Project

Figure 33: 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

Related Topics

Data Visualizations Using Unifier Data

Forecasted Cost Analytics Overview Dashboard

Submittals Overview Dashboard

Tracking Maintenance Status Dashboard



Last Published Friday, December 8, 2023