TM1 Function for Rules, SCAN

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

Where can the SCAN function be used?

Rules and TurboIntegrator

Which TM1 Server version is this function available for?

Version 11 and 12

What is the SCAN function?

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

What is the syntax for SCAN?

SUBST(substring, String)​
​Substring = A text string​
String = A text string 

A demonstration on how to use SCAN

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.