You use the Aggregate Query Detailsscreen in the SAP Manufacturing Integration and Intelligence (SAP MII) Workbenchto configure steps for the aggregate query.
You can use the Set Common Target Params button to set commonly mapped parameters including time parameters for time-sensitive queries. If you are using a time-sensitive query and want all underlying queries to use the same time and duration, you can map all time parameters to all underlying queries.
Aggregate Query Parameters
Parameter |
Data Type |
Description |
SourceTemplate.1 - SourceTemplate.32 |
String |
Fully-qualified template name used by the aggregate query object. For example, UserTemplates/LineSpeedQuery. |
SourceName.1 - SourceName.32 |
String |
User-defined template name for the source template. For example, PlantLineSpeeds. |
MappedParamSource.1 - MappedParamSource.32 |
String |
Query parameter from the aggregate query object to apply to the MappedParamTarget in the template. For example, Param.1. |
MappedParamTarget.1 - MappedParamTarget.32 |
String |
Query parameter in the source template used to map the MappedParamSource. The format is <SourceName>.<QueryParameter>. Use an asterisk to map the parameter to all associated SourceTemplates. For example, *.StartDate. |
To pass parameters to the underlying queries, you must map the aggregate query parameters to the underlying query template parameters. You can do the following:
Map a parameter to the same parameter in all queries
Map a parameter to a parameter in one query