You use the properties in the following table to configure the control limits for the lower chart of your SAP Manufacturing Integration and Intelligence (SAP MII) statistical process control (SPC) charts.
The following table lists the lower chart control limit properties:
Property Name | Parameter Name | Data Type |
Column for Upper Ctrl Limit of Lower Chart | LowerUCLColumn | String |
Column for Lower Control Limit | LowerCLColumn | String |
Column for Lower Control Limit of Lower Chart | LowerLCLColumn | String |
Calculate Control Limits | LowerCalculateControlLimits | Boolean |
Source of Lower Control Limit | LowerControlLimitSource | String |
Param.[number] of Lower Control Limit(For example, Param. 1 of Lower Control Limit) | LowerControlLimitParam.[number] (For example, LowerControlLimitParam.1) | String |
Upper Control Limit of Lower Chart | LowerUCL | Floating point |
Lower Control Limit | LowerCL | Floating point |
Lower Control Limit of Lower Chart | LowerLCL | Floating point |
The Source of Lower Control Limit references a query and defines the location of the control limits for the lower chart. 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 result set may have multiple rows. You can use the effective date and the date and time value of the returned data to determine which set of limits to use.
You can use the lower control limit parameter values with the LowerControlLimitSource query. The system replaces the token values in brackets with the name and type of the chart. The default value for Param. 1 of Lower Control Limit is [CHARTNAME]. The default value for Param. 2 of Lower Control Limit is [CHARTTYPE].
If the data query returns the control limits, you can identify the columns in the query that represent the lower control limit of the lower chart, lower control limit, and upper control limit of the lower chart. Additional queries do not have to be run to return the limits.