Hi Folks,
In the grand old days of perspectives I was able to build an active form with the option to do a wildcard search, to do this I ensured the alias was populated in the TM1RPTROW and then the mdx part of the TM1RPTROW would reference a cell.
The mdx would be something like: ="{TM1Sort(TM1FilterByPattern({TM1SubsetAll([Employee])},"&""""&"*"&Sheet1!$D$18&"*"&""""&"), ASC)}"
So if I entered Smith in cell D18 all the Employees with Smith in their name would be returned.
I have tried to do the exact same thing in PAX and it doesn't return any rows, it is as if the alias is not recognised. The only way I can get TM1FilterByPattern to work is if I clear the alias and search for the actual element name, which kind of defeats the object, given users want to search for names and not employee numbers!
I can get round this by using the INSTR function in the MDX instead but wondered if anyone else had noticed this behaviour or had any insights?
regards,
Mark
Paid Advertisement:
