Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    NValue function for IBM Planning Analytics (TM1)

      NValue is a TM1 reserved local variable that determines if the current cell is numeric.

      In this video, NValue will be used to export data to a file, if it’s numeric.

      Where can the NValue function be used?

      TurboIntegrator

        Which TM1 Server version is the NValue function available for?

        Version 11 and 12

          What is the syntax for NValue?

          NValue = N;

          • N = 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