| | Technical Field definitions: |
|---|
Adoption - Overall Score % | (1*[5BEBC-2A5]+1*[D0C11-590]+1*[E1326-758]+1*[72B3C-28E]+1*[9E42A-5CD])/5 | {
"[D0C11-590]": {
"type": "measure",
"formula": "SUM([B3B9B-BBC],SUM([92E9F-F43],CASE WHEN[1077A-4D0]>0 THEN 1 ELSE 0 END))/(COUNT([92E9F-F43])* COUNT([B3B9B-BBC]))",
"context": {
"[1077A-4D0]": {
"table": "Fact Core",
"column": "Scrap including unscheduled",
"dim": "[Fact Core.Scrap including unscheduled]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Scrap including unscheduled"
},
"[92E9F-F43]": {
"table": "Dim Dates",
"column": "Calendar DateTime",
"dim": "[Dim Dates.Calendar DateTime (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Calendar DateTime"
},
"[B3B9B-BBC]": {
"table": "Dim Machines",
"column": "Machine Name",
"dim": "[Dim Machines.Machine Name]",
"datatype": "text",
"merged": true,
"title": "Machine Name"
}
},
"title": "Adoption - Machines Reporting Scrap %"
},
"[E1326-758]": {
"type": "measure",
"formula": "SUM([28512-5C5],SUM([350ED-E4B],CASE WHEN[5F0D7-F14]>0 THEN 1 ELSE 0 END))/(COUNT([350ED-E4B])*COUNT([28512-5C5]))",
"context": {
"[350ED-E4B]": {
"table": "Dim Dates",
"column": "Calendar DateTime",
"dim": "[Dim Dates.Calendar DateTime (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Calendar DateTime"
},
"[5F0D7-F14]": {
"table": "Fact Core",
"column": "Comment Count",
"dim": "[Fact Core.Comment Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Comment Count"
},
"[28512-5C5]": {
"table": "Dim Machines",
"column": "Machine Name",
"dim": "[Dim Machines.Machine Name]",
"datatype": "text",
"merged": true,
"title": "Machine Name"
}
},
"title": "Adoption - Machines With Comments %"
},
"[72B3C-28E]": {
"type": "measure",
"formula": "(sum([DF275-498]),[84BB1-A37],[B23D3-A16])/([BB919-196],[84BB1-A37])",
"context": {
"[BB919-196]": {
"table": "Fact Core",
"column": "Total Hours",
"dim": "[Fact Core.Total Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Total Hours"
},
"[DF275-498]": {
"table": "Fact Core",
"column": "Total Hours",
"dim": "[Fact Core.Total Hours]",
"datatype": "numeric",
"title": "Total Hours"
},
"[B23D3-A16]": {
"table": "Dim Reasons",
"column": "Reason Name",
"dim": "[Dim Reasons.Reason Name]",
"datatype": "text",
"merged": true,
"title": "Reason Name"
},
"[84BB1-A37]": {
"table": "Dim States",
"column": "State Type",
"dim": "[Dim States.State Type]",
"datatype": "text",
"merged": true,
"title": "State Type"
}
},
"title": "Adoption - Downtime With Reason %"
},
"[9E42A-5CD]": {
"type": "measure",
"formula": "(SUM([E216F-4A3]),[EB339-F49])/[E216F-4A3]",
"context": {
"[E216F-4A3]": {
"table": "Fact Core",
"column": "Uptime Hours",
"dim": "[Fact Core.Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Uptime Hours"
},
"[EB339-F49]": {
"table": "Dim Jobs",
"column": "Job Name",
"dim": "[Dim Jobs.Job Name]",
"datatype": "text",
"merged": true,
"title": "Job Name"
}
},
"title": "Adoption - Uptime With Job %"
},
"[5BEBC-2A5]": {
"type": "measure",
"formula": "SUM([99531-28B])/[9E46F-7A8]",
"context": {
"[99531-28B]": {
"table": "Fact Core",
"column": "Good Performance Hours",
"dim": "[Fact Core.Good Performance Hours]",
"datatype": "numeric",
"title": "Good Performance Hours"
},
"[9E46F-7A8]": {
"table": "Fact Core",
"column": "Uptime Hours",
"dim": "[Fact Core.Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Uptime Hours"
}
},
"title": "Adoption - Proper Rates %"
}
} |
Adoption - Proper Rates % | SUM([99531-28B])/[9E46F-7A8] | {
"[99531-28B]": {
"table": "Fact Core",
"column": "Good Performance Hours",
"dim": "[Fact Core.Good Performance Hours]",
"datatype": "numeric",
"title": "Good Performance Hours"
},
"[9E46F-7A8]": {
"table": "Fact Core",
"column": "Uptime Hours",
"dim": "[Fact Core.Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Uptime Hours"
}
}</TD><TR>
<TD>Adoption - Uptime With Job %</TD><TD>(SUM([E216F-4A3]),[EB339-F49])/[E216F-4A3]</TD><TD>{
"[E216F-4A3]": {
"table": "Fact Core",
"column": "Uptime Hours",
"dim": "[Fact Core.Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Uptime Hours"
},
"[EB339-F49]": {
"table": "Dim Jobs",
"column": "Job Name",
"dim": "[Dim Jobs.Job Name]",
"datatype": "text",
"merged": true,
"title": "Job Name"
}
} |
Adoption - Machines With Comments % (detail) | (COUNT([6CA84-0DE]),[437FC-8E2])/COUNT([6CA84-0DE]) | {
"[437FC-8E2]": {
"table": "Fact Core",
"column": "Comment Count",
"dim": "[Fact Core.Comment Count]",
"datatype": "numeric",
"title": "Comment Count"
},
"[6CA84-0DE]": {
"table": "Dim Machines",
"column": "Machine Name",
"dim": "[Dim Machines.Machine Name]",
"datatype": "text",
"merged": true,
"title": "Machine Name"
}
} |
Adoption - Machines With Comments % | SUM([28512-5C5],SUM([350ED-E4B],CASE WHEN[5F0D7-F14]>0 THEN 1 ELSE 0 END))/(COUNT([350ED-E4B])*COUNT([28512-5C5])) | {
"[350ED-E4B]": {
"table": "Dim Dates",
"column": "Calendar DateTime",
"dim": "[Dim Dates.Calendar DateTime (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Calendar DateTime"
},
"[5F0D7-F14]": {
"table": "Fact Core",
"column": "Comment Count",
"dim": "[Fact Core.Comment Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Comment Count"
},
"[28512-5C5]": {
"table": "Dim Machines",
"column": "Machine Name",
"dim": "[Dim Machines.Machine Name]",
"datatype": "text",
"merged": true,
"title": "Machine Name"
}
} |
Adoption - Machines Reporting Scrap % (detail) | (COUNT([AF083-749]),[8DC0F-842])/COUNT([AF083-749]) | {
"[8DC0F-842]": {
"table": "Fact Core",
"column": "Scrap including unscheduled",
"dim": "[Fact Core.Scrap including unscheduled]",
"datatype": "numeric",
"title": "Scrap including unscheduled"
},
"[AF083-749]": {
"table": "Dim Machines",
"column": "Machine Name",
"dim": "[Dim Machines.Machine Name]",
"datatype": "text",
"merged": true,
"title": "Machine Name"
}
} |
Adoption - Machines Reporting Scrap % | SUM([B3B9B-BBC],SUM([92E9F-F43],CASE WHEN[1077A-4D0]>0 THEN 1 ELSE 0 END))/(COUNT([92E9F-F43])* COUNT([B3B9B-BBC])) | {
"[1077A-4D0]": {
"table": "Fact Core",
"column": "Scrap including unscheduled",
"dim": "[Fact Core.Scrap including unscheduled]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Scrap including unscheduled"
},
"[92E9F-F43]": {
"table": "Dim Dates",
"column": "Calendar DateTime",
"dim": "[Dim Dates.Calendar DateTime (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Calendar DateTime"
},
"[B3B9B-BBC]": {
"table": "Dim Machines",
"column": "Machine Name",
"dim": "[Dim Machines.Machine Name]",
"datatype": "text",
"merged": true,
"title": "Machine Name"
}
} |
Adoption - Downtime With Reason % | (sum([DF275-498]),[84BB1-A37],[B23D3-A16])/([BB919-196],[84BB1-A37]) | {
"[BB919-196]": {
"table": "Fact Core",
"column": "Total Hours",
"dim": "[Fact Core.Total Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Total Hours"
},
"[DF275-498]": {
"table": "Fact Core",
"column": "Total Hours",
"dim": "[Fact Core.Total Hours]",
"datatype": "numeric",
"title": "Total Hours"
},
"[B23D3-A16]": {
"table": "Dim Reasons",
"column": "Reason Name",
"dim": "[Dim Reasons.Reason Name]",
"datatype": "text",
"merged": true,
"title": "Reason Name"
},
"[84BB1-A37]": {
"table": "Dim States",
"column": "State Type",
"dim": "[Dim States.State Type]",
"datatype": "text",
"merged": true,
"title": "State Type"
}
} |
MTBF | sum([6D2CF-61E]) / [D7FD8-6F4] | {
"[6D2CF-61E]": {
"dim": "[Fact Core.Duration for MTBF]",
"datatype": "numeric",
"title": "Duration For MTBF"
},
"[D7FD8-6F4]": {
"dim": "[Fact Core.Stops]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Stops"
}
} |
MTTR | sum([2838A-80C]) / [61C59-8C8] | {
"[2838A-80C]": {
"dim": "[Fact Core.Duration for MTTR]",
"datatype": "numeric",
"title": "Duration For MTTR"
},
"[61C59-8C8]": {
"dim": "[Fact Core.Stops]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Stops"
}
} |
ReasonState Occurrences | (Sum([F9B46-ACF]), [9F349-BAD]) + (sum([A9BE6-F02]), [B115F-5EB]) | {
"[A9BE6-F02]": {
"dim": "[Fact Core.Reason Occurrences]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Reason Occurrences"
},
"[F9B46-ACF]": {
"dim": "[Fact Core.State Occurrences]",
"datatype": "numeric",
"agg": "sum",
"title": "Total State Occurrences"
},
"[B115F-5EB]": {
"dim": "[Dim Reasons.Reason Name]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"N\A"
]
}
},
"title": "Reason Name"
},
"[9F349-BAD]": {
"dim": "[Dim Reasons.Reason Name]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"N\A"
]
},
"title": "Reason Name"
},
"[C0FBE-134]": {
"dim": "[Dim Reasons.Reason Name]",
"datatype": "text",
"merged": true,
"title": "Reason Name"
}
} |
Oee | (sum([9D576-A8C]), [8CEF5-512]) / ([9F41D-329],[8CEF5-512]) | {
"[9D576-A8C]": {
"dim": "[Fact Core.OeeProductive]",
"datatype": "numeric",
"agg": "sum",
"title": "Total OeeProductive"
},
"[9F41D-329]": {
"dim": "[Fact Core.Total Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Total Hours"
},
"[8CEF5-512]": {
"dim": "[Fact Core.Is Scheduled]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"true"
]
},
"collapsed": true,
"title": "Is Scheduled"
}
} |
OeeC | [C2975-A71] /[7AF5D-84E] | {
"[C2975-A71]": {
"dim": "[Fact Core.OeeProductive]",
"datatype": "numeric",
"agg": "sum",
"title": "Total OeeProductive"
},
"[7AF5D-84E]": {
"dim": "[Fact Core.Total Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Total Hours"
}
} |
Availability | [02ADB-869] / [562F8-DB8] | {
"[562F8-DB8]": {
"dim": "[Fact Core.Scheduled Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Scheduled Hours"
},
"[02ADB-869]": {
"dim": "[Fact Core.Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Uptime Hours"
}
} |
Performance | (sum([A013D-BEA]), [F9255-DF8] ) / [50862-8A7] | {
"[50862-8A7]": {
"dim": "[Fact Core.Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Uptime Hours"
},
"[A013D-BEA]": {
"dim": "[Fact Core.OeeRuntime]",
"datatype": "numeric",
"agg": "sum",
"title": "Total OeeRuntime"
},
"[F9255-DF8]": {
"dim": "[Fact Core.Is Scheduled]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"true"
]
},
"collapsed": true,
"title": "Is Scheduled"
}
} |
PerformanceC | (sum([04047-4A8]),[B1047-E69] ) / [B4E03-041] | {
"[B4E03-041]": {
"dim": "[Fact Core.Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Uptime Hours"
},
"[04047-4A8]": {
"dim": "[Fact Core.OeeRuntime]",
"datatype": "numeric",
"agg": "sum",
"title": "Total OeeRuntime"
},
"[B1047-E69]": {
"dim": "[Fact Core.Is Scheduled]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": false,
"multiSelection": true,
"all": true
},
"collapsed": true,
"title": "Is Scheduled"
}
} |
Quality | (sum([5E5C1-4ED]) , [EA1C3-138]) / ([99B2C-F68],[503F0-EF0]) | {
"[5E5C1-4ED]": {
"dim": "[Fact Core.OeeProductive]",
"datatype": "numeric",
"agg": "sum",
"title": "Total OeeProductive"
},
"[99B2C-F68]": {
"dim": "[Fact Core.OeeRuntime]",
"datatype": "numeric",
"agg": "sum",
"title": "Total OeeRuntime"
},
"[503F0-EF0]": {
"dim": "[Fact Core.Is Scheduled]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"true"
]
},
"collapsed": true,
"title": "Is Scheduled"
},
"[EA1C3-138]": {
"dim": "[Fact Core.Is Scheduled]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"true"
]
},
"collapsed": true,
"title": "Is Scheduled"
}
} |
QualityC | (sum([275F0-263]),[037B8-B2A] ) / ([EB4CF-F64], [037B8-B2A]) | {
"[275F0-263]": {
"dim": "[Fact Core.OeeProductive]",
"datatype": "numeric",
"agg": "sum",
"title": "Total OeeProductive"
},
"[EB4CF-F64]": {
"dim": "[Fact Core.OeeRuntime]",
"datatype": "numeric",
"agg": "sum",
"title": "Total OeeRuntime"
},
"[037B8-B2A]": {
"dim": "[Fact Core.Is Scheduled]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": false,
"multiSelection": true,
"all": true
},
"collapsed": true,
"title": "Is Scheduled"
}
} |
Scrap Rate | sum([CF692-53A]) / [0F819-6EF] | {
"[0F819-6EF]": {
"dim": "[Fact Core.Total Production]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Total Production"
},
"[CF692-53A]": {
"dim": "[Fact Core.Scrap]",
"datatype": "numeric",
"title": "Scrap"
}
} |
Good Rate | sum([9B330-749]) / [E0CA2-E4E] | {
"[E0CA2-E4E]": {
"dim": "[Fact Core.Total Production]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Total Production"
},
"[9B330-749]": {
"dim": "[Fact Core.Good Production]",
"datatype": "numeric",
"title": "Good Production"
}
} |
Parts/min Actual | (sum([27493-373]), [D73C4-EBD] ) / ([8460C-EB9]* 60) | {
"[8460C-EB9]": {
"dim": "[Fact Core.Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Uptime Hours"
},
"[D73C4-EBD]": {
"dim": "[Dim ReasonStates.ReasonState Type]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Uptime",
"SpeedLoss"
]
},
"collapsed": true,
"title": "ReasonState Type",
},
"[27493-373]": {
"dim": "[Fact Core.Total Production]",
"datatype": "numeric",
"title": "Total Production"
},
"[83266-01C]": {
"dim": "[Dim ReasonStates.ReasonState Type]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Uptime"
]
},
"collapsed": true,
"title": "ReasonState Type"
}
} |
Parts/min Expected | [5080F-119] / ([34FC9-D39] * 60) | {
"[5080F-119]": {
"dim": "[Fact Core.Expected Production]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Expected Production"
},
"[34FC9-D39]": {
"dim": "[Fact Core.Scheduled Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Scheduled Hours"
}
} |
Parts/min Gauge | (sum([1FB9F-786]), [A7FD5-39A] ) / ([6D000-43B]* 60) - ([5E501-2BE] / ([2092B-E57] * 60)) | {
"[5E501-2BE]": {
"dim": "[Fact Core.Expected Production]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Expected Production"
},
"[2092B-E57]": {
"dim": "[Fact Core.Scheduled Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Scheduled Hours"
},
"[6D000-43B]": {
"dim": "[Fact Core.Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Uptime Hours"
},
"[A7FD5-39A]": {
"dim": "[Dim ReasonStates.ReasonState Type]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Uptime",
"SpeedLoss"
]
},
"collapsed": true,
"title": "ReasonState Type",
},
"[1FB9F-786]": {
"dim": "[Fact Core.Total Production]",
"datatype": "numeric",
"title": "Total Production"
}
} |
Parts/Hour Expected | [C8A24-E42] / [5473D-9DF] | {
"[C8A24-E42]": {
"dim": "[Fact Core.Expected Production]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Expected Production"
},
"[5473D-9DF]": {
"dim": "[Fact Core.Scheduled Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Scheduled Hours"
}
} |
Parts/Hour Actual | (sum([2A952-CDF]), [F1B8B-E3A] ) / ([4DB30-248]) | {
"[4DB30-248]": {
"dim": "[Fact Core.Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Uptime Hours"
},
"[F1B8B-E3A]": {
"dim": "[Dim ReasonStates.ReasonState Type]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Uptime",
"SpeedLoss"
]
},
"collapsed": true,
"title": "ReasonState Type",
},
"[2A952-CDF]": {
"dim": "[Fact Core.Total Production]",
"datatype": "numeric",
"title": "Total Production"
}
} |
Parts/Hour Gauge | (sum([C0528-0EE]), [CD223-244] ) / ([8F343-7DE]) - [24642-B7C] | {
"[24642-B7C]": {
"type": "measure",
"formula": "[C8A24-E42] / [5473D-9DF]",
"context": {
"[C8A24-E42]": {
"dim": "[Fact Core.Expected Production]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Expected Production"
},
"[5473D-9DF]": {
"dim": "[Fact Core.Scheduled Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Scheduled Hours"
}
},
"title": "Parts/Hour Expected"
},
"[8F343-7DE]": {
"dim": "[Fact Core.Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Uptime Hours"
},
"[CD223-244]": {
"dim": "[Dim ReasonStates.ReasonState Type]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Uptime",
"SpeedLoss"
]
},
"collapsed": true,
"title": "ReasonState Type",
},
"[C0528-0EE]": {
"dim": "[Fact Core.Total Production]",
"datatype": "numeric",
"title": "Total Production"
}
} |
Capacity | [FCECC-459] / (sum([BC3E5-547]), [20B99-4D8]) | {
"[FCECC-459]": {
"dim": "[Fact Core.Scheduled Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Scheduled Hours"
},
"[20B99-4D8]": {
"dim": "[Fact Core.Is Scheduled]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": false,
"multiSelection": true,
"all": true
},
"collapsed": true,
"title": "Is Scheduled"
},
"[BC3E5-547]": {
"dim": "[Fact Core.Total Hours]",
"datatype": "numeric",
"title": "Total Hours"
}
} |
Line Oee | (sum([340B3-1FC]), [C316A-C8B]) / [05A49-BCD] | {
"[05A49-BCD]": {
"dim": "[Fact Core Lines.Line Scheduled Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Line Scheduled Hours"
},
"[340B3-1FC]": {
"dim": "[Fact Core Lines.LineOeeProductive]",
"datatype": "numeric",
"agg": "sum",
"title": "Total LineOeeProductive"
},
"[C316A-C8B]": {
"dim": "[Fact Core Lines.Line Is Scheduled]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"true"
]
},
"collapsed": true,
"title": "Line Is Scheduled"
}
} |
Line OeeC | [89157-D7F] /[E7C97-34A] | {
"[89157-D7F]": {
"dim": "[Fact Core Lines.LineOeeProductive]",
"datatype": "numeric",
"agg": "sum",
"title": "Total LineOeeProductive"
},
"[E7C97-34A]": {
"dim": "[Fact Core Lines.Line Total Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Line Total Hours"
}
} |
Line Availability | [04139-A38] / [FD4AC-8D9] | {
"[FD4AC-8D9]": {
"dim": "[Fact Core Lines.Line Scheduled Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Line Scheduled Hours"
},
"[04139-A38]": {
"dim": "[Fact Core Lines.Line Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Line Uptime Hours"
}
} |
Line Performance | (sum([BE05C-B67]), [1A8C9-C69] ) / [DE872-6DA] | {
"[DE872-6DA]": {
"dim": "[Fact Core Lines.Line Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Line Uptime Hours"
},
"[BE05C-B67]": {
"dim": "[Fact Core Lines.LineOeeRuntime]",
"datatype": "numeric",
"agg": "sum",
"title": "Total LineOeeRuntime"
},
"[1A8C9-C69]": {
"dim": "[Fact Core Lines.Line Is Scheduled]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"true"
]
},
"collapsed": true,
"title": "Line Is Scheduled"
}
} |
Line Quality | ([44EAB-3E6], [70C5A-D3F]) / ([7712C-8AD],[70C5A-D3F]) | {
"[44EAB-3E6]": {
"dim": "[Fact Core Lines.LineOeeProductive]",
"datatype": "numeric",
"agg": "sum",
"title": "Total LineOeeProductive"
},
"[7712C-8AD]": {
"dim": "[Fact Core Lines.LineOeeRuntime]",
"datatype": "numeric",
"agg": "sum",
"title": "Total LineOeeRuntime"
},
"[70C5A-D3F]": {
"dim": "[Fact Core Lines.Line Is Scheduled]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"true"
]
},
"collapsed": true,
"title": "Line Is Scheduled"
}
} |
Line PerformanceC | (sum([34C91-610])) / [50497-DAF] | {
"[50497-DAF]": {
"dim": "[Fact Core Lines.Line Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Line Uptime Hours"
},
"[34C91-610]": {
"dim": "[Fact Core Lines.LineOeeRuntime]",
"datatype": "numeric",
"agg": "sum",
"title": "Total LineOeeRuntime"
}
} |
Line QualityC | ([8D938-163]) / ([BB896-500]) | {
"[8D938-163]": {
"dim": "[Fact Core Lines.LineOeeProductive]",
"datatype": "numeric",
"agg": "sum",
"title": "Total LineOeeProductive"
},
"[BB896-500]": {
"dim": "[Fact Core Lines.LineOeeRuntime]",
"datatype": "numeric",
"agg": "sum",
"title": "Total LineOeeRuntime"
}
} |
Job Variance | [E1008-286] + [BE85C-60E] - [FF708-50C] - ([5D9B9-081], [BE31C-0EB], [5996C-1E2])
| {
"[E1008-286]": {
"dim": "[Dim Jobs.Job Runtime Expected]",
"datatype": "numeric",
"agg": "avg",
"title": "Average Job Runtime Expected"
},
"[BE85C-60E]": {
"dim": "[Dim Jobs.Job Expected Setup]",
"datatype": "numeric",
"agg": "avg",
"title": "Average Job Expected Setup"
},
"[FF708-50C]": {
"dim": "[Fact Core.Scheduled Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Scheduled Hours"
},
"[5D9B9-081]": {
"dim": "[Fact Core.Total Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Total Hours"
},
"[BE31C-0EB]": {
"dim": "[Dim ReasonStates.ReasonState Type]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Uptime",
"SpeedLoss"
]
},
"collapsed": true,
"title": "ReasonState Type"
},
"[5996C-1E2]": {
"dim": "[Fact Core.Is Scheduled]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"false"
]
},
"collapsed": true,
"title": "Is Scheduled"
}
} |
Job Runtime Variance | [D2882-5ED] - [9FCE6-B86] - ([2A508-792],[21C45-61B],[A5FA2-A0A]) | {
"[D2882-5ED]": {
"dim": "[Dim Jobs.Job Runtime Expected]",
"datatype": "numeric",
"agg": "avg",
"title": "Average Job Runtime Expected"
},
"[9FCE6-B86]": {
"dim": "[Fact Core.Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Uptime Hours"
},
"[2A508-792]": {
"dim": "[Fact Core.Total Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Total Hours"
},
"[21C45-61B]": {
"dim": "[Dim ReasonStates.ReasonState Type]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Uptime"
]
},
"collapsed": true,
"title": "ReasonState Type"
},
"[A5FA2-A0A]": {
"dim": "[Fact Core.Is Scheduled]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"false"
]
},
"collapsed": true,
"title": "Is Scheduled"
}
} |
Job Setup Variance | [3B6E7-A8E]- ([23F02-430] , [62340-114]) | {
"[3B6E7-A8E]": {
"dim": "[Dim Jobs.Job Expected Setup]",
"datatype": "numeric",
"agg": "avg",
"title": "Average Job Expected Setup"
},
"[23F02-430]": {
"dim": "[Fact Core.Scheduled Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Scheduled Hours"
},
"[62340-114]": {
"dim": "[Dim ReasonStates.ReasonState Type]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Setup"
]
},
"collapsed": true,
"title": "ReasonState Type"
},
"[0251C-A61]": {
"dim": "[Dim ReasonStates.ReasonState Type]",
"datatype": "text",
"merged": true,
"title": "ReasonState Type"
}
} |
Job Production Variance | [AE3AA-C21] - [C6717-467] | {
"[AE3AA-C21]": {
"dim": "[Dim Jobs.Job Expected Production]",
"datatype": "numeric",
"agg": "avg",
"title": "Average Job Expected Production"
},
"[C6717-467]": {
"dim": "[Fact Core.Total Production]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Total Production"
}
} |
Part Cycle Time Actual (sec / part) | [2391D-E24]*3600 / (sum([6DFEE-49F]), [46BF8-F64] ) | {
"[2391D-E24]": {
"dim": "[Fact Core.Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Uptime Hours"
},
"[46BF8-F64]": {
"dim": "[Dim ReasonStates.ReasonState Type]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Uptime",
"SpeedLoss"
]
},
"collapsed": true,
"title": "ReasonState Type",
},
"[6DFEE-49F]": {
"dim": "[Fact Core.Total Production]",
"datatype": "numeric",
"title": "Total Production"
}
} |
Part Cycle Time Expected (sec / part) | [DC705-5A6] * 3600 / [5A25A-6F9] | {
"[5A25A-6F9]": {
"dim": "[Fact Core.Expected Production]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Expected Production"
},
"[DC705-5A6]": {
"dim": "[Fact Core.Scheduled Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Scheduled Hours"
}
} |
SPM Expected (cycle/min) | (sum([A5B1B-4B7]),[6FEBB-CF4]) / (60 * [5353F-1C4]) | {
"[5353F-1C4]": {
"dim": "[Fact Core.Scheduled Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Scheduled Hours"
},
"[A5B1B-4B7]": {
"dim": "[Fact Core.Expected Cycles]",
"datatype": "numeric",
"title": "Expected Cycles"
},
"[6FEBB-CF4]": {
"table": "Fact Core",
"column": "Is Scheduled",
"dim": "[Fact Core.Is Scheduled]",
"datatype": "text",
"merged": true,
"title": "Is Scheduled",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"true"
]
},
"collapsed": true,
}
} |
SPM Gauge (cycle/min) | [E4DA9-E02] - [3E11F-9C8] | {
"[3E11F-9C8]": {
"type": "measure",
"formula": "(sum([A5B1B-4B7]),[6FEBB-CF4]) / (60 * [5353F-1C4])",
"context": {
"[5353F-1C4]": {
"dim": "[Fact Core.Scheduled Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Scheduled Hours"
},
"[A5B1B-4B7]": {
"dim": "[Fact Core.Expected Cycles]",
"datatype": "numeric",
"title": "Expected Cycles"
},
"[6FEBB-CF4]": {
"table": "Fact Core",
"column": "Is Scheduled",
"dim": "[Fact Core.Is Scheduled]",
"datatype": "text",
"merged": true,
"title": "Is Scheduled",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"true"
]
},
"collapsed": true,
}
},
"title": "SPM Expected (cycle/min)"
},
"[E4DA9-E02]": {
"type": "measure",
"formula": "(SUM([1A98F-132]),[6FEF3-26B]) / ([FE689-DDD]* 60 )",
"context": {
"[FE689-DDD]": {
"dim": "[Fact Core.Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Uptime Hours"
},
"[6FEF3-26B]": {
"dim": "[Dim ReasonStates.ReasonState Type]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Uptime",
"SpeedLoss"
]
},
"collapsed": true,
"title": "ReasonState Type",
},
"[F9C68-025]": {
"dim": "[Dim ReasonStates.ReasonState Type]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Uptime"
]
},
"collapsed": true,
"title": "ReasonState Type"
},
"[1A98F-132]": {
"dim": "[Fact Core.Cycles]",
"datatype": "numeric",
"title": "Cycles"
}
},
"title": "SPM Actual (cycle/min)"
}
} |
SPM Actual (cycle/min) | (SUM([FA4F9-FE1]),[D7FB4-C0E]) / ([0EBF1-AA2]* 60 ) | {
"[0EBF1-AA2]": {
"dim": "[Fact Core.Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Uptime Hours"
},
"[D7FB4-C0E]": {
"dim": "[Dim ReasonStates.ReasonState Type]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Uptime",
"SpeedLoss"
]
},
"collapsed": true,
"title": "ReasonState Type",
},
"[86238-F0D]": {
"dim": "[Dim ReasonStates.ReasonState Type]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Uptime"
]
},
"collapsed": true,
"title": "ReasonState Type"
},
"[FA4F9-FE1]": {
"dim": "[Fact Core.Cycles]",
"datatype": "numeric",
"title": "Cycles"
}
} |
Good Production Including Unscheduled | sum([9496B-B4D]) - [FF56A-D06] | {
"[9496B-B4D]": {
"dim": "[Fact Core.Total Production including unscheduled]",
"datatype": "numeric",
"title": "Total Production including unscheduled"
},
"[FF56A-D06]": {
"dim": "[Fact Core.Scrap including unscheduled]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Scrap including unscheduled"
}
} |
Uptime Including Unscheduled | (sum([FC86C-024]),[70EBE-42C] ) | {
"[70EBE-42C]": {
"dim": "[Dim ReasonStates.ReasonState Type]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"SpeedLoss",
"Uptime"
]
},
"collapsed": true,
"datasource": {
"fullname": "localhost/dev13_v00013",
"id": "localhost_adev13XwAav00013",
"address": "LocalHost",
"database": "adev13XwAav00013",
"live": false,
"title": "dev13_v00013"
},
"title": "ReasonState Type"
},
"[FC86C-024]": {
"dim": "[Fact Core.Total Hours]",
"datatype": "numeric",
"title": "Total Hours"
}
} |
Part Cycle Time Gauge (sec/part) | [4585A-E99]*3600 / (sum([E44B6-EF9]), [D3ED9-E2D] ) - [3DC53-E29] | {
"[3DC53-E29]": {
"type": "measure",
"formula": "[DC705-5A6] * 3600 / [5A25A-6F9]",
"context": {
"[5A25A-6F9]": {
"dim": "[Fact Core.Expected Production]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Expected Production"
},
"[DC705-5A6]": {
"dim": "[Fact Core.Scheduled Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Scheduled Hours"
}
},
"title": "Part Cycle Time Expected (sec / part)"
},
"[7CB3A-234]": {
"table": "Fact Core",
"column": "Total Production",
"dim": "[Fact Core.Total Production]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Total Production"
},
"[4585A-E99]": {
"dim": "[Fact Core.Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Uptime Hours"
},
"[D3ED9-E2D]": {
"dim": "[Dim ReasonStates.ReasonState Type]",
"datatype": "text",
"merged": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Uptime",
"SpeedLoss"
]
},
"collapsed": true,
"title": "ReasonState Type",
},
"[E44B6-EF9]": {
"table": "Fact Core",
"column": "Total Production",
"dim": "[Fact Core.Total Production]",
"datatype": "numeric",
"title": "Total Production"
}
} |
Cycle Time Actual (sec) | 3600* [C60F3-25B] / ([243A5-306],[E6042-38D]) | {
"[C60F3-25B]": {
"table": "Fact Core",
"column": "Uptime Hours",
"dim": "[Fact Core.Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Uptime Hours"
},
"[E6042-38D]": {
"table": "Dim ReasonStates",
"column": "ReasonState Type",
"dim": "[Dim ReasonStates.ReasonState Type]",
"datatype": "text",
"merged": true,
"title": "ReasonState Type",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"SpeedLoss",
"Uptime"
]
},
"collapsed": true,
},
"[243A5-306]": {
"table": "Fact Core",
"column": "Cycles",
"dim": "[Fact Core.Cycles]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Cycles"
}
} |
Cycle Time Expected (sec) | 3600 * [9B644-F65] / ([A2C4D-A97],[E9DDC-828]) | {
"[A2C4D-A97]": {
"table": "Fact Core",
"column": "Expected Cycles",
"dim": "[Fact Core.Expected Cycles]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Expected Cycles"
},
"[9B644-F65]": {
"table": "Fact Core",
"column": "Scheduled Hours",
"dim": "[Fact Core.Scheduled Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Scheduled Hours"
},
"[E9DDC-828]": {
"table": "Fact Core",
"column": "Is Scheduled",
"dim": "[Fact Core.Is Scheduled]",
"datatype": "text",
"merged": true,
"title": "Is Scheduled",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"true"
]
},
"collapsed": true,
}
} |
Cycle Time Gauge (sec) | 3600* [A87C3-192] / ([6FBD2-C39],[0CB7D-D20]) - (3600 * [3AEC2-3FE] / ([BBC4B-38F], [7DF62-4DA])) | {
"[BBC4B-38F]": {
"table": "Fact Core",
"column": "Expected Cycles",
"dim": "[Fact Core.Expected Cycles]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Expected Cycles"
},
"[3AEC2-3FE]": {
"table": "Fact Core",
"column": "Scheduled Hours",
"dim": "[Fact Core.Scheduled Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Scheduled Hours"
},
"[A87C3-192]": {
"table": "Fact Core",
"column": "Uptime Hours",
"dim": "[Fact Core.Uptime Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Uptime Hours"
},
"[0CB7D-D20]": {
"table": "Dim ReasonStates",
"column": "ReasonState Type",
"dim": "[Dim ReasonStates.ReasonState Type]",
"datatype": "text",
"merged": true,
"title": "ReasonState Type",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"SpeedLoss",
"Uptime"
]
},
"collapsed": true,
},
"[7DF62-4DA]": {
"table": "Fact Core",
"column": "Is Scheduled",
"dim": "[Fact Core.Is Scheduled]",
"datatype": "text",
"merged": true,
"title": "Is Scheduled",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"true"
]
},
"collapsed": true,
},
"[6FBD2-C39]": {
"table": "Fact Core",
"column": "Cycles",
"dim": "[Fact Core.Cycles]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Cycles"
}
} |
Job Rate (blended) | [41BAF-489] / [22737-82A] | {
"[41BAF-489]": {
"table": "Fact Core",
"column": "Expected Production",
"dim": "[Fact Core.Expected Production]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Expected Production"
},
"[22737-82A]": {
"table": "Fact Core",
"column": "Scheduled Hours",
"dim": "[Fact Core.Scheduled Hours]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Scheduled Hours"
}
} |
Job Cycle Factor (blended) | [4EDF5-EDC] / ([8131F-945], [E4CD6-6D5]) | {
"[4EDF5-EDC]": {
"table": "Fact Core",
"column": "Expected Production",
"dim": "[Fact Core.Expected Production]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Expected Production"
},
"[8131F-945]": {
"table": "Fact Core",
"column": "Expected Cycles",
"dim": "[Fact Core.Expected Cycles]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Expected Cycles"
},
"[E4CD6-6D5]": {
"table": "Fact Core",
"column": "Is Scheduled",
"dim": "[Fact Core.Is Scheduled]",
"datatype": "text",
"merged": true,
"title": "Is Scheduled",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"true"
]
},
"collapsed": true,
}
} |
| | |