TM1 Function for TI – WILDCARDFILESEARCH
WILDCARDFILESEARCH searches files using wildcard characters in a folder.
WildcardFileSearch (Pathname, PriorFilename);
Pathname = A file path including file search criteria that can contain a wildcard character. For eg:
PriorFilename = Name of the existing file in the folder. If we pass empty string argument, then the function returns the first file which matches the criteria
Use a While loop to go through all the elements in the Product Scorecard dimension.