Data mapping is required in SAP Manufacturing Integration and Intelligence (SAP MII) to link columns returned from a query to elements in a statistical process control (SPC) chart.
The following table lists the data mapping parameters for an SPC chart:
Property Name |
Parameter Name |
Data Type |
---|---|---|
X-Axis Label Attributes |
XAxisLabelAttribute |
String |
Show Attribute Columns |
AttributeColumns |
String |
Show Value Columns |
ValueColumns |
String |
Timestamp Columns |
TimestampColumn |
String |
ID Columns |
IDColumns |
String |
Name of the Highlight Attribute |
HighlightAttributeName |
String |
Value of the Highlight Attribute |
HighlightAttributeValue |
String |
Mouse Over Attribute Name |
MouseOverAttributeName |
String |
The following table shows partial results from a sample SQL query, QueryABC, that are used in the steps below:
Sale Amount |
Order ID |
Company Name |
Shipped Date |
2556.95 |
10393 |
Save-a-lot Markets |
01/03/1997 00:00:00 |
2505.60 |
10398 |
Save-a-lot Markets |
01/09/1997 00:00:00 |
3868.60 |
10401 |
Rattlesnake Canyon Grocery |
01/10/1997 00:00:00 |
2713.50 |
10402 |
Ernst Handel |
01/10/1997 00:00:00 |
Enter the query template name.
In this example, it is QueryABC.
Click Load.
Data appears under Column Names.
If you want to evaluate the Sale Amount using statistical analysis, select S aleAmount in the Column Names list.
Click Add under Valu eColumns.
Most SPC charts can have only one value column.
Select other columns that are not part of the statistical calculations but contain data that you want to include in your chart.
Click Add under Attribute Columns.
You can add the Order ID, Company Name, and Shipped Date as attribute columns. When you are viewing the chart, use the secondary mouse button menu to see the attribute values for each point. You may also use the mouse-over parameter.
If the data query returns a sample size column and you want to use it instead of a static value for attribute charts, select the column from the drop-down list.
Enter a time stamp column.
This column is used to identify the date-time column of time sensitive queries. It is also used to identify break points in the control limits. If you change control limits and set an effective date, it identifies which limits to use. It is required for limit transactions in the chart.