Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    SValue function for IBM Planning Analytics (TM1)

      SValue is a TM1 reserved local variable determining whether the current cell is a string.

      In this video, SValue will be used to identify if the ‘Product Scorecard’ cube’s data type is string or numeric.

      Where can the SValue function be used?

      TurboIntegrator

        Which TM1 Server version is the SValue function available for?

        Version 11 and 12

          What is the syntax for SValue?

          SValue = ‘string’;

          • string = value of the current cell

          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