MicroStrategy ONE

PatternMatch

This function defines a transaction in terms of a Derived Attribute. One or more attribute elements or metric values will be mapped to the same transaction group (assign the same integer number) if matching with a given pattern.

Syntax

PatternMatch<Breakby, SortBy>(ValueList, Pattern, maxNum)

Where:

ValueList is either be a list of attribute elements or metric values.

Pattern is a pattern for given input to be matched with. Such pattern is defined using a regular expression or simply {%string} to match with any string.

maxNum is the maximum number of elements allowed within the same transaction group (assigned with the same integer number). "-1" value indicates no limitation.