FileExists function for IBM Planning Analytics (TM1)

    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