Analytics Data Dictionary - Formula Technical Definitions

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,
 }
}