MicroStrategy ONE

PatternMatchCorr

This function defines a transaction in terms of a Derived Attribute. Given attribute elements or metric values are mapped to the same transaction group only if input1 (ValueList1) matches with a pre-defined pattern and input2 (ValueList2) qualifies on certain conditions.

Syntax

PatternMatchCorr<Breakby, SortBy>(ValueList1, Pattern, ValueList2, maxPairDiff, maxDiff, maxNum)

Where:

  • ValueList1/ValueList2 are either lists of attribute elements or metric values.
  • Pattern specifies a pattern for ValueList1 to be matched with. Such pattern is defined using a regular expression or simply {%string} to match with any string.
  • maxPairDiff specifies the maximum difference allowed between the neighbor elements within ValueList2 to be mapped to the same transaction group (assign the same integer number). "-1" value indicates no limitation.
  • maxDiff specifies the maximum difference between the minimum and the maximum elements within ValueList2 to be mapped to the same transaction group (assign the same integer 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.