Show TOC

Function documentationUse Parameters in Expressions of PIC Analysis Query Reports

 

In addition to constants, parameters can also be passed to expressions in PIC analysis query reports. You can define the parameter values for your PIC analysis query reports either in SAP MII Workbench or in SSCE (Self Service Composition Environment).

In total 32 parameters can be used. The parameter name is predefined as Param.<No.>. For example, Param.1.

When passing a parameter to an expression, be sure to enclose the parameter in single quotes plus brackets: '[Parameter Name]'. For example: "EMA_Equipment.EMA_Equipment.Equipment_ID“ = ‘[Param.1]’.

Activities

Define Parameter Values in SAP MII Workbench

  1. In SAP MII Workbench, create a catalog query in the mode of PICAnalysis.

  2. On the Template categories tab, double-click PIC Analysis Query Details.

  3. Define all necessary PIC analysis query details, following the instructions in PIC Analysis Query Details.

    When defining expressions, you can use any one of the 32 parameters.

  4. On the Template categories tab, double-click Parameters.

    A parameters table is displayed.

  5. To test run the PIC analysis query report, define a value for each parameter used.

  6. Save the PIC analysis query report.

Define Parameter Values in SSCE

  1. In SSCE, in the design dashboard, open a PIC analysis query template.

  2. Choose Configure Query Parameters (Configure Query Parameters).

    The Configure Query Parameters window appears.

  3. Choose Add and then in the Select Parameters window, select and add Parameters.

  4. Back in the Configure Query Parameters window, you can change the PIC analysis query details and parameter values, if necessary.

More Information

For more information about using parameters in PIC analysis query reports, see: