Data Collection Cube#

This cube collects information regarding Data Collections and SPC Chart Data Point.

Dimensions#

This section describes the dimensions of the Data Collection cube

Area - Contains all Areas available in the system during the cube processing

Chart - Contains all Charts available in the system during the cube processing. Notice that this dimension includes an attribute called Chart Start date time that indicates the first time a new pair of Lower Spec Limit and Upper Spec Limit is used on a series for Chart Name, Chart type and Type. This dimension is required for calculating CPK values

Data Collection - Contains all Data Collections available in the system during the cube processing

Data Collection String Value - Contains all Data Collections String Values available in the system during the cube processing

Data - Contains all Calendar days used in the system

Employee - Contains all Employees available in the system during the cube processing

Facility - Contains all Facilities available in the system during the cube processing

Flow - Contains all Flows available in the system during the cube processing

Flow Path - Contains all Flow Paths available in the system during the cube processing

Logical Flow Path - Contains all Logical Flow Paths available in the system during the cube processing

Material - Contains all Materials available in the system during the cube processing

Parameter - Contains all Parameters available in the system during the cube processing. Notice that parameters from Checklists and Protocols are also included in this dimension

Product - Contains all Products available in the system during the cube processing

Product Group - Contains all Products groups available in the system during the cube processing

Production Order - Contains all Production orders available in the system during the cube processing

Operation - Contains all Operations defined on the system during the cube processing

Reading Number - Contains all Reading Numbers defined on the system during the cube processing

Resource - Contains all Resources defined on the system during the cube processing

Sample - Contains all Sample IDs defined on the system during the cube processing

Step - Contains all Steps defined on the system during the cube processing

Time - Day time representation. All seconds of a day are available (max: 235959)

Unit - Primary - The units of measurement that represents the Primary Quantity

Unit - Secondary - The unit of measurement that represents the Secondary Quantity

Measure Groups#

There are two measure groups in the Data Collection cube:

• Data Collection
• Chart Data Point

Data Collection#

This section describes the Data Collection Measure Group

Average Value - The average value for a data collection

Min Value - The minimum value for a data collection

Max Value - The maximum value for a data collection

Value - The data collection value

Data Collection Count - The number of data collections

Material Primary Quantity - The Material Primary quantity during the data collection event

Material Secondary Quantity - The Material Secondary quantity during the data collection event

Sub Materials Primary Quantity - The Sub Material Primary quantity during the data collection event

Sub Materials Secondary Quantity - The Sub Material Secondary quantity during the data collection event

Chart Data Point#

This section describes the Chart Data Point Measure Group

Process Capability (Cp) - Process capability compares the output of an in-control process to the specification limits by using capability indexes. The comparison is made by forming the ratio of the spread between the process specifications (the specification "width") to the spread of the process values as measured by 6 process standard deviation units (the process width)

\(C_p=\frac{USL-LSL}{6\hat{\delta}_{Data Point}}\)

This value is only visible (not null) when specific dimension attributes are filtered or displayed. These attributes are:

[Chart].[Chart Name]
[Chart].[Chart Start Date Time]

Process Capability (Cpl) - This is the lower boundary of Process Capability

\(C_{pl}=\frac{\mu-LSL}{3\delta}\)

This value is only visible (not null) when specific dimension attributes are filtered or displayed. These attributes are:

[Chart].[Chart Name]
[Chart].[Chart Start Date Time]

Process Capability (Cpu) - This is the upper boundary of Process Capability

\(C_{pu}=\frac{USL-\mu}{3\delta}\)

This value is only visible (not null) when specific dimension attributes are filtered or displayed. These attributes are:

[Chart].[Chart Name]
[Chart].[Chart Start Date Time]

Process Capability Index (Cpk) - The Process Capability Index (Cpk) measures the process capability. It shows how closely a process is able to produce the output to its overall specifications

\(C_{pk}=min(\frac{USL-\mu}{3\delta},\frac{\mu-LSL}{3\delta})\)

[Chart].[Chart Name]
[Chart].[Chart Start Date Time]

Data Point Average (\(\mu\)) - This is the average of Data Point Value 1

Data Point Count - This is the count of a group of readings. If the Chart is reading 4 values each 5 minutes, after 15 minutes Data Point Count would be 3, and Data Point Reading Count would be 12

Data Point Median - This is the median of Data Point Value 1

Data Point Range - Difference between the maximum Data Point Value 1 and the minimum Data Point Value 1

Data Point Reading Value - Actual value of the reading. This value is only visible (not null) when specific dimension attributes are filtered or displayed. These attributes are:

[Chart].[Chart Name]
[Chart].[Chart Start Date Time]
[Data Point].[Data Point Name]
[Sample].[Sample Id]
[Reading Number].[Reading Number]

For displaying individual reading values, besides the attributes listed above, Date and Time would also have to be added to filter/presentation (Data Point Reading Count must be 1)

Data Point StdDev (\(\delta\)) - This is the standard deviation of Data Point Value 1

Data Point Value 1 - This is the first calculated value based on the reading values and the type of the Chart. As an example, considering an Average And Range chart, this would be the Average of the reading values. This value is only visible (not null) when specific dimension attributes are filtered or displayed. These attributes are:

[Chart].[Chart Name]
[Chart].[Chart Start Date Time]
[Data Point].[Data Point Name]
[Sample].[Sample Id]
[Reading Number].[Reading Number]

Data Point Value 2 - This is the second calculated value based on the reading values and the type of the chart. As an example, considering an Average And Range chart, this would be the range of the reading values. This value is only visible (not null) when specific dimension attributes are filtered or displayed. These attributes are:

[Chart].[Chart Name]
[Chart].[Chart Start Date Time]
[Data Point].[Data Point Name]
[Sample].[Sample Id]
[Reading Number].[Reading Number]

Lower Control Limit 1 - This is the lower control limit 1 of the chart data point. This value is only visible (not null) when specific dimension attributes are filtered or displayed. These attributes are:

[Chart].[Chart Name]
[Chart].[Chart Start Date Time]
[Data Point].[Data Point Name]
[Sample].[Sample Id]
[Reading Number].[Reading Number]

Lower Control Limit 2 - This is the lower control limit 2 of the chart data point. This value is only visible (not null) when specific dimension attributes are filtered or displayed. These attributes are:

[Chart].[Chart Name]
[Chart].[Chart Start Date Time]
[Data Point].[Data Point Name]
[Sample].[Sample Id]
[Reading Number].[Reading Number]

Lower Spec Limit (LSL) - This is the lower limit of the chart data point. This value is only visible (not null) when specific dimension attributes are filtered or displayed. These attributes are:

[Chart].[Chart Name]
[Chart].[Chart Start Date Time]

Upper Control Limit 1 - This is the upper control limit 1 of the chart data point. This value is only visible (not null) when specific dimension attributes are filtered or displayed. These attributes are:

[Chart].[Chart Name]
[Chart].[Chart Start Date Time]
[Data Point].[Data Point Name]
[Sample].[Sample Id]
[Reading Number].[Reading Number]

Upper Control Limit 2 - This is the upper control limit 2 of the chart data point. This value is only visible (not null) when specific dimension attributes are filtered or displayed. These attributes are:

[Chart].[Chart Name]
[Chart].[Chart Start Date Time]
[Data Point].[Data Point Name]
[Sample].[Sample Id]
[Reading Number].[Reading Number]

Upper Spec Limit (USL) - This is the upper limit of the chart data point. This value is only visible (not null) when specific dimension attributes are filtered or displayed. These attributes are:

[Chart].[Chart Name]
[Chart].[Chart Start Date Time]

Dimensions and Measure Groups#

The table below lists the relationship between Data Collection dimensions and measure groups

Table: Data Collection Cube - Dimensions and Measure Groups