Show TOC

Function documentationiSPCChart Data Mapping Locate this document in the navigation structure

 

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.

Features

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

Example

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

  1. Enter the query template name.

    In this example, it is QueryABC.

  2. Click Load.

    Data appears under Column Names.

  3. If you want to evaluate the Sale Amount using statistical analysis, select S aleAmount in the Column Names list.

  4. Click Add under Valu eColumns.

    Most SPC charts can have only one value column.

  5. Select other columns that are not part of the statistical calculations but contain data that you want to include in your chart.

  6. 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.

  7. 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.

  8. 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.