Rule Functions

TM1 Function for Rules – SCAN

Available In

Rules and TurboIntegrator

Definition

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

Syntax

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.