Value_Is_String function for IBM Planning Analytics (TM1)

    Where can the Value_Is_String function be used?

      Which TM1 Server version is the Value_Is_String function available for?

        What is the syntax for Value_Is_String?

        • ​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