WildCardFileSearch function for IBM Planning Analytics (TM1)

Where can the WildCardFileSearch function be used?

TurboIntegrator

Which TM1 Server version is the WildCardFileSearch function available for?

Version 11 and 12

What is the syntax for WildCardFileSearch?

WildCardFileSearch(Pathname, PriorFilename)

• Pathname = A file path including file search criteria that can contain a wildcard character. (eg: C:WildcardFileSearchP*​)
• PriorFilename = Name of the existing file in the folder. If we pass an empty string argument, then the function returns the first file that matches the criteria

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