Show TOC

Function documentationAggregate Query Details Locate this document in the navigation structure

 

You use the Aggregate Query Detailsscreen in the SAP Manufacturing Integration and Intelligence (SAP MII) Workbenchto configure steps for the aggregate query.

Features

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.

Activities

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