Page Comparison

...

Category	Measure	Definition	Example
Dim Areas	Division	The area levels above the Plant. Multiple levels will show only the highest 3 levels.
	Division2	The area levels above the Plant. Multiple levels will show only the highest 3 levels.
	Division3	The area levels above the Plant. Multiple levels will show only the highest 3 levels.
	Line	The area level configured as Line.
	Line Area	The area levels below the Line. Mutiple levels will show only the highest 3 levels.
	Line Area2	The area levels below the Line. Mutiple levels will show only the highest 3 levels.
	Line Area3	The area levels below the Line. Mutiple levels will show only the highest 3 levels.
	Plant	The area level configured as Plant.
	Plant Area	The area levels below the Plant. Mutiple levels will show only the highest 4 levels
	Plant Area2	The area levels below the Plant. Mutiple levels will show only the highest 4 levels
	Plant Area3	The area levels below the Plant. Mutiple levels will show only the highest 4 levels
	Plant Area4	The area levels below the Plant. Mutiple levels will show only the highest 4 levels
Dim Dates	Calendar DateTime	Calendar DateTime_DayDate	Calendar DateTime_key	Calendar DateTime_QuarterDate	CalendarDateTime_YearDatePreferred Date to use – this is the machine time. Multiple timezones.. ??
Dim Jobs	Job Blocked Cycle Factor	How many cavities are blocked per cycle.
	Job Cycle Factor - Finished Goods
	Job Blocked Cycle Factor - Inventory
	Job Blocked Cycle Factor - Line	Anthony Scaletti (Unlicensed)
	Job Blocked Cycle Factor - Scrap	Anthony Scaletti (Unlicensed)
	Job Description	Job Due DateTime	Job Due DateTime_DayDate	Job Due DateTime_key	Job Due DateTime_QuarterDate
	Job Due DateTime_YearDate	Job End DateTime	Job End DateTime_DayDate	Job End DateTime_key	Job End DateTime_MonthDate	Job End DateTime_QuarterDate
	Job End DateTime_YearDate
	Job Expected Electricity
	Job Expected Employees
	Job Expected Gas
	Job Expected Production
	Job Expected Runspeed
	Job Expected Setup
	Job Expected Water
	Job Filter 01 - 20
	Job Instance
	Job Is Local
	Job Max Run Rate
	Job Name
	Job Next Operation
	Job Operation
	Job Pull GroupJob Ship DateTime
	Job Ship DateTime_DayDate
	Job Ship DateTime_key	Job Ship DateTime_MonthDate	Job Ship DateTime_QuarterDate	Job Ship DateTime_QuarterDate	Job Ship DateTime_YearDate	Job Start DateTime	Job Start DateTime_DayDate	Job Start DateTime_key	Job Start DateTime_MonthDate	Job Start DateTime_QuarterDate	Job Start DateTime_YearDate
	Job Status Blocked
	Job Status Confirmed
	Job Status Edited
	Job Status Is Current
	Job Status Pulled
	Job Timestamp	Job Timestamp_DayDate	Job Timetamp_key	Job Timestamp_MonthDate	Job Timestamp_QuarterDate	Job Timestamp_YearDate
Dim Machines	Is Line	Machine Id	Machine NameDim Machines	Is Line	If the machine is a line or not. A Line is expressed as a machine that has this flag set to true. Since a line is expressed in the same production stats as a machine, we create an “Line Machine” with: Machine Name = Line Name Machine Id = Line_(bottleneck line machine Id) This “Line Machine” allows analytics as if the line was a single machine in native line units.
	Machine Id	system field.
	Machine Name	Machine Name as configured
Dim Reasons	Reason Classification	Reason’s Classification as configured in the Machine’s variables tab.
	Reason Group1-4	Reason Group as configured in a Machine’s variables tab.
	Reason Name	Reason Name
	Reason Type	Reason’s
Dim ReasonState	ReasonState Classification	ReasonState is a combination of Reason and State – all properties of Dim ReasonState are the Reason’s properties when a reason is present. When no reason is present, the State properties are used.
	ReasonState Group 1-4	“
	ReasonState Name	“
	ReasonState Type	“
Dim Recent Shifts	Shift Recency	Shift Start	Shift Start_DayDate	Shift Start_key	Shift Start_MonthDate	Shift Start_QuarterDate	Shift Start_YearDateRecency is one of 3 values: All 24 hours 7 days This is an INCLUSIVE way to include the last 24 hours.
Dim Scrap Reasons	Scrap Group	Scrap Reason group as configured.
	Scrap Reason	Scrap Reason as configured in the Machine’s variables tab.
Dim Shift Instances	Shift Instance	A unique identifier to distinguish this shift from others with its name and start date.
	Shift NameShift Start DateTime	As configured in the shift calendar
	Shift Start DateTime_DayDate	Shift Start DateTime_key	Shift Start DateTime_MonthDate	Shift Start_QuarterDate	Shift Start_YearDate	When the Shift Started.
Dim States	State ClassificationState Group1-4	Performance, Capacity, or Availability.
	State Name	State Name as configured.
Fact Core	Expected Production	Job Rate, or if there is no Job Rate, then the Machine Rate.
	Good ProductionJob Rate	Total Production - Scrap
	OeeProductiveOeeProductiveC	Used to calculate OEE. Good / Rate
	OeeRuntimeOeeRuntimeC	Used to calculate OEE. Total / Rate
	OeeScrapByRateOeeScrapByRateC	Used to calculate OEE. Scrap / Rate
	Reason Occurrences	Number of times the Reason was entered, for any duration.
	ReasonState	see Dim ReasonState.
	Scheduled Hours	Hours during scheduled shifts. Excludes capacity reasons and capacity states.
	Scrap	Scrap in scheduled time.
	Scrap Including Unscheduled	Scrap, All.
	State Occurrences	Number of times the State was entered, for any duration.
	Total Hours	Clock Time.
	Total Production	Parts produced in scheduled time.
	Total Production Including Unscheduled	Parts produced including parts from unscheduled time.
	Uptime Hours	Hours where the StateType is: Uptime; or Speed Loss
Fact Scrap Reasons	Scrap Reason Amount	IMPORTANT: Scrap Reason DateTime	Scrap Reason DateTime_DayDate	Scrap Reason DateTime_key	Scrap Reason DateTime_MonthDate	Scrap Reason DateTime_QuarterDate	Scrap Reason DateTime_YearDate	Scrap Reason ShiftAmount is the amount for just the associated scrap reason (from Dim Scrap Reason). If you are working with Scrap but not interested in reasons, then use [Fact Core].[Scrap]. If you are interested in reasons, once you add this field, the inner join will eliminate all Fact Core rows so you will want to create side by side to best analyze Scrap Reasons alongside Fact Core fields.

Versions Compared

Old Version 8

New Version 9

Key

Related articles