Transformation 
You use the Transformation screen for queries to define an SAP Manufacturing Integration and Intelligence inline transform and the parameters used by the transform. You use the inline transformation to provide additional reshaping, aggregation, or other manipulation of a data set before it is rendered. A number of inline transformations are provided with the SAP Manufacturing Integration and Intelligence (SAP MII) installation. You can use these transformations to provide mechanisms for reshaping or performing common data transformation tasks on XML data sets being generated from SAP MII queries. The inline transformations are not directly responsible for controlling the visual output of a query but are used to alter the data content by converting it from one SAP MII XML data set to another. The resultant data set can then be used by any other SAP MII component like applets, reports, and so on.
The inline transform is used within an individual query, as opposed to the Stylesheet parameter, which may be generically applied to any query to format the output. The inline transform is used to perform query-specific manipulation of returning data . Also, it can be used to output additional information that is not explicitly provided in the original data query. Predefined stylesheets are also available that can be applied to any query. For more information, see Stylesheets.
The following are a few examples describing the inline transform:
Calculate a range between values
Calculate a running sum for a column
Providing data summaries by inputting raw values through a specific algorithm
Filter specific columns from a data query, or filter a specific value or range of values
If parameter values are not provided at runtime, the default values are used. If you overwrite the default values, the system only reads the values of the <xsl:param> nodes, which are children of the first <xsl:stylesheet> node of the XSL.
For example, if you use the following XSLT code, the parameter passes into the transform:
<xsl:stylesheet version="2.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:java="http://xml.apache.org/xslt/java"
exclude-result-prefixes="java">
<xsl:output method="xml" media-type="text/xml" encoding="UTF-8"/>
<xsl:template match="/">
<xsl:param name="ParamName">ParamValue</xsl:param>
If you use the following code, the transform works:
<xsl:stylesheet version="2.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:java="http://xml.apache.org/xslt/java"
exclude-result-prefixes="java">
<xsl:output method="xml" media-type="text/xml" encoding="UTF-8"/>
<xsl:param name="ParamName">ParamValue</xsl:param>
You can use this function as an efficient mechanism for manipulating the queried data.
See also: