Value_Is_String function for IBM Planning Analytics (TM1)
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.
In this video, Value_Is_String will be used to identify the data type from the ‘Product Scorecard’ cube.
Where can the Value_Is_String function be used?
TurboIntegrator
Which TM1 Server version is the Value_Is_String function available for?
Version 11 and 12
What is the syntax for Value_Is_String?
Value_Is_String = N;
- N = if a 0 is returned, it is a number, otherwise the cell is a string.
Relevant Functions
- MinorErrorLogMax = Sets the maximum number of minor errors written in the TM1 process error log file
- NValue = A TM1 reserved local variable. We don’t need to define this variable to use it in the TM1 script
- OnMinorErrorDoItemSkip = Instructs the process to skip to the next record when a minor error is encountered
- SValue = A TM1 reserved local variable. We don’t need to define this variable to use it in the TM1 script
- TM1ProcessError.log = Generates a log file when a process encounters an error
- Value_Is_String = A reserved local variable that checks if the data source type is a string or number