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
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
Last Published Friday, December 8, 2023