PAX Dynamic Form FILTERBYPATTERN MDX

Post Reply
Mark RMBC
Regular Participant
Posts: 209
Joined: Tue Sep 06, 2016 7:55 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

PAX Dynamic Form FILTERBYPATTERN MDX

Post by Mark RMBC » 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

Post Reply