MicroStrategy ONE

PatternMatchDiff

This function defines a transaction in terms of a Derived Attribute. One or more given attribute elements or metric values are mapped to the same transaction group (assign the same integer number) if certain conditions (specified by parameters: maxPairDiff, maxDiff and maxNum) are met.

Syntax

PatternMatchDiff<Breakby, SortBy>(ValueList, maxPairDiff, maxDiff, maxNum)

Where:

  • ValueList can either be a list of attribute elements or metric values.
  • maxPairDiff specifies the maximum difference allowed between the neighbor elements within the ValueList to be mapped to the same transaction group (assigned with the same transaction number). "-1" value indicates no limitation.
  • maxDiff specifies the maximum difference between the first and the last elements within the ValueList to be mapped to the same transaction group (assigned with the same transaction number). "-1" value indicates no limitation.
  • maxNum specifies the maximum number of elements allowed within the same transaction group (assigned with the same integer number). "-1" value indicates no limitation.