TM1 Function for TI, VALUE_IS_STRING
A reserved local variable that checks if the data source type is a string or number.
What is the VALUE_IS_STRING function?
VALUE_IS_STRING is a reserved local variable that checks if the data source type is a string or number. If the function return ‘1’, then the value is a string, otherwise it is numeric. For reserved variables, we don’t need to define it in the script.
Where can the VALUE_IS_STRING function be used?
TurboIntegrator
What is the syntax for VALUE_IS_STRING?
VALUE_IS_STRING;
A demonstration on how to use VALUE_IS_STRING
Use VALUE_IS_STRING to identify the data type from the ‘Product Scorecard’ cube.