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.