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