Show TOC

Function documentationi5Chart Data Mapping

 

You use this when you use an SAP Manufacturing Integration and Intelligence (SAP MII) i5Chart display template with all queries. You must configure data mapping properties so the columns returned from the query can be linked to other elements (such as a legend, descriptions, or data values) in the chart.

Features

Values selected in the Label Columns form the X-axis on the chart. For Y-axis, the system calculates the range based on the minimum and maximum values of the fields defined in Value Columns. The graph is plotted using the values available in the fields of Value Columns against the Label Columns values.

Example Example

Consider the profit of car sales for the months January and February in China. If the profit for the month of January is 50 and February is 150, the Value Column displays the range of measure between 0 and 150. The graph is plotted using the label column values and value column values in the range 0 to 150.

End of the example.

You can hover over the data points in the chart to display the tool tip that shows the values of X- and Y- axes at selected points. The legend area describes the colors and column names used to render the chart. For details on the chart behaviors and graphical representation, see Available Chart Types.

Based on the given query template, the system displays the column names as configured in the query template.

The following table lists the i5Chart data mapping properties:

Property Name

Parameter Name

Data Type

Description

Value Columns

ValueColumns

String List

Define which data columns from the configured query are used as values to plot the chart. In other words, the Value Columns represent the measures used to plot the chart.

Label Columns

LabelColumns

String List

Define which data columns from the configured query are used to create the reference X-axis when the system renders the chart. In other words, these data columns represent the dimensions for a chart.

Note Note

  • By default, the first data column available in Column Names box represents X-axis if the columns are not specified in Label Columns.

  • If you specify two or more data columns in the Label Columns, the last data column is combined with the values of the Value Columns.

End of the note.

Activities

On the Data Mapping screen in the SAP MII Workbench, you can define which column values to plot the chart and which to use as the reference axis.

You can change these parameter values in web pages such as HTML and IRPT pages. For more information, see Web Page Scripting for i5Charts.