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
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.