Tracking Maintenance Status Dashboard
Description: Tracking open and closed work orders by week over time.
Number of Canvases: 4
Default Canvas: Issues
Canvas/Dashboard Name: Tracking Maintenance Status
Data Source(s): Unifier
Subject Area: N/A
Datasets: Created and Completed BP Overtime Dataset
Dashboard(s)
Table 55: Tracking Maintenance Status – Dimensions
| Canvas | Dimension Name | Dimension / Attribute | Subject Area / Dataset |
|---|---|---|---|
| Issues by Building | Week Name | Created and Completed BP Overtime Dataset | |
| All Canvases | Status | Created and Completed BP Overtime Dataset | |
| By Building Table | Project Name | Created and Completed BP Overtime Dataset | |
| Table Details | Project Name (Root Level) | Created and Completed BP Overtime Dataset | |
| Table Details | Project Hierarchy Name Level 1 | Created and Completed BP Overtime Dataset | |
| Details | Record Number | Created and Completed BP Overtime Dataset | |
| Details | Title | Created and Completed BP Overtime Dataset |
Table 56: Tracking Maintenance Status – Measures
| Canvas | Fact / Measure | Measure Type | Subject Area / Dataset |
|---|---|---|---|
|
Issues By Building Table |
# of BP Records | Fact | Created and Completed BP Overtime Dataset |
|
Issues By Building |
# of Created BP Records | Calculated from Fact | Created and Completed BP Overtime Dataset |
|
Issues By Building |
# of Completed BP Records | Calculated from Fact | Created and Completed BP Overtime Dataset |
Table 57: Tracking Maintenance Status – Filters
| Canvas | Filter Type | Is Expression Filter | Dimension / Attribute / Measure | Subject Area / Dataset |
|---|---|---|---|---|
| All Canvases | Dashboard | No | Project Portfolio Name | Created and Completed BP Overtime Dataset |
| All Canvases | Dashboard | No | Project Name | Created and Completed BP Overtime Dataset |
| All Canvases | Visualization | No | Status | Created and Completed BP Overtime Dataset |
| All Canvases | Dashboard & Visualization | No | Business Process Name | Created and Completed BP Overtime Dataset |
|
Issues By Building |
Dashboard & Visualization | No | Open Cases Tag | Created and Completed BP Overtime Dataset |
Table 58: Tracking Maintenance Status – Calculated Members
| Calculated Member | Expression | Source | Subject Area / Dataset (s) |
|---|---|---|---|
| # of Created BP Records |
CASE WHEN XSA('demouser'.'Created and Completed BP Over Time Dataset')."Columns"."Creation Date" >= XSA('demouser'.'Created and Completed BP Over Time Dataset')."Columns"."Week Start Date" AND XSA('demouser'.'Created and Completed BP Over Time Dataset')."Columns"."Creation Date" <= XSA('demouser'.'Created and Completed BP Over Time Dataset')."Columns"."Week End Date" THEN 1 ELSE 0 END
|
Derived From Fact | Created and Completed BP Overtime Dataset |
| # of Completed BP Records | CASE WHEN XSA('demouser'.'Created and Completed BP Over Time Dataset')."Columns"."Completion Date" >= XSA('demouser'.'Created and Completed BP Over Time Dataset')."Columns"."Week Start Date" AND XSA('demouser'.'Created and Completed BP Over Time Dataset')."Columns"."Completion Date" <= XSA('demouser'.'Created and Completed BP Over Time Dataset')."Columns"."Week End Date" THEN 1 ELSE 0 END | Derived From Fact | Created and Completed BP Overtime Dataset |