Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    FileExists function for IBM Planning Analytics (TM1)

      FileExists searches if a file exists in a folder. If the file exists, then 1 is returned, otherwise 0 is returned. 

      In this video, FileExists is used to check if the file, Product Scorecard.txt and ProductScorecard.txt, exists in a folder.

      Where can the FileExists function be used?

      TurboIntegrator

        Which TM1 Server version is the FileExists function available for?

        Version 11 and 12

          What is the syntax for FileExists?

          FileExist(File)

          • File = File full name, including file extension and path.

          Relevant Functions

          • AddInfoCubeRestriction = Filters InfoCube data as it is pulled into TM1. Use this function to restrict the values that are imported for a specified characteristic
          • Expand = Expands variable names, enclosed in % signs
          • FileExists = Searches if a file exists in a folder. If the file exists, then 1 is returned, otherwise 0 is returned
          • LogOutput = Writes a message to the tm1server.log file
          • TM1User = Returns the user logged in
          • WildcardFileSearch = Searches files using wildcard characters in a folder