You use these properties to configure the upper chart control limits of your SAP Manufacturing Integration and Intelligence (SAP MII) statistical process control (SPC) charts.
The following table lists upper chart control limit properties:
Property Name | Parameter Name | Data Type |
Upper Ctrl Limit Column of Upper Chart | UpperUCLColumn | String |
Center Line Column of Upper Chart | UpperCLColumn | String |
Lower Ctrl Limit Column of Upper Chart | UpperLCLColumn | String |
Calculate Control Limits | UpperCalculateControlLimits | Boolean |
Source for Upper Control Limit | UpperControlLimitSource | String |
Param. [number] for Upper Control Limit(For example, Param. 1 for Upper Control Limit) | UpperControlLimitParam.[number] (For example, UpperControlLimitParam.1) | String |
Upper Ctrl Limit of Upper Chart | UpperUCL | Floating point |
Upper CL | UpperCL | Floating point |
Lower Control Limit of Upper Chart | UpperLCL | Floating point |
The Source for Upper Control Limit references a query template and defines the location of the control limits for the chart template. The data must be returned in dataset format with the columns in the following order: effectivity date (datetime datatype), LCL (number datatype), target (number datatype), UCL (number datatype). The resulting set can have multiple rows. You can use the effectivity date and the datetime value of the returned data to determine which set of limits to use.
You use the upper control limit parameter values with the UpperControlLimitSource query. The system replaces the token values in brackets with the name and type of the chart. The default value for Param. 1 for Upper Control Limit is [CHARTNAME]. The default value for Param. 2 for Upper Control Limit is [CHARTTYPE]. For more information, see iSPCChart Chart Area Properties.
If the data query returns the control limits, you can identify the columns in the query that represent the upper chart lower control limit, upper chart control limit, and upper chart upper control limit. Additional queries do not have to be run to return the limits.