Filter Parameter syntax
Certain macros allow you to use an additional parameter to filter the selection used in the macro. These are the macros that include filter options.
- RunInterfaceService
- CallForecastEngine
- ClearMeasure
- DeleteMIEvent
- CopyCyclePeriodData
- CallReplenishmentEngine
For the selected Measure, filtering is based on item@location. For example, only items@location in the macro selection that pass the filter condition are applicable to the macro.
Filter is applied at PConst using measure values for the applicable item@location combinations. Measures with no values at PConst consider the filter as invalid. Calculated measures must be defined as business metrics for them to be used in a filter.
Any macros called by a parent macro which contains filters, also be governed by the filter defined at the parent macro.
Filters defined in child macros will only be considered, if the parent macro has no filter defined.
This table lists the examples of syntax format for the filter.
| Syntax | Example |
|---|---|
| [MeasureCode] condition [MeasureCode] | [SPLS_STOCK_QTYOH] > [SPLS_STOCK_COVER] |
| [MeasureCode] condition value | [TUPLE_EXISTS_D] > 0 |
| value condition [MeasureCode] | 0 < [DPLS_FSMPITEM] |
| [%measurecontext%] condition [MeasureCode] | [%measurecontext%] > [SPLS_STOCK_COVER] |
| [MeasureCode] condition [%measurecontext%] | [SPLS_STOCK_COVER] < [%measurecontext%] |
| [%measurecontext%] condition value | [%measurecontext%] > 0 |
| value condition [%measurecontext%] | 0 != [%measurecontext%] |
| [MeasureCode] operator [MeasureCode] condition value | [DPLS_FSTAT]+[DPLS_FMI] > 0 |
| [MeasureCode] operator [MeasureCode] condition [MeasureCode] | [DPLS_FSTAT]+[DPLS_FMI] > [DPLS_FUNITS] |
The %measurecontext% variable is only valid when the macro is run in a multi-panel destination worksheet with a panel link that has Pass Measure = TRUE.
| Conditions allowed |
|---|
| < |
| < |
| >= |
| =< |
| == |
| != |
| Operators allowed |
|---|
| + |
| - |
| * |
| / |