PAX Dynamic Form FILTERBYPATTERN MDX
Posted: Thu Jan 09, 2020 10:36 am
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
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