Rule Functions

TM1 Function for Rules – SCAN

Available In

Rules and TurboIntegrator


SCAN searches the specified substring within a string and returns the starting position of the substring. 


SUBST(substring, String)

Substring = A text string

String = A text string 

Video Demo

Use SCAN function to find the substring within a string and apply it in the rule to populate the Commission measure in the Product Scorecard cube.