Multiple Wildcard Filter/search

Post Reply
nimol
Posts: 20
Joined: Fri Jun 10, 2011 6:12 am
OLAP Product: TM1
Version: 1022
Excel Version: 2010

Multiple Wildcard Filter/search

Post by nimol »

Hi,

can anyone advise whether you can make multiple wildcard searches in TM1? To give an example say that you have a dimension and you don't have the complete name of elements to find. I know you can use filter by wildcard function in subset editor and use * if you don't have the complete name. However if you like to create a view consisting of several elements but in order to find those elements how could you use multiple filter by wildcard? Is it possible? If not any other alternatives?

Thanks
User avatar
qml
MVP
Posts: 1096
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Multiple Wildcard Filter/search

Post by qml »

A dynamic subset can give you that by combining multiple TM1FILTERBYPATTERN statements in one MDX formula. Depending on how flexible you need this subset to be, it could even pull the wildcards to search from a parameter cube.
Kamil Arendt
nimol
Posts: 20
Joined: Fri Jun 10, 2011 6:12 am
OLAP Product: TM1
Version: 1022
Excel Version: 2010

Re: Multiple Wildcard Filter/search

Post by nimol »

Thanks, I guess there is no way you can type in multiple conditions directly into filter by wildcard function?
Alan Kirk
Site Admin
Posts: 6647
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Multiple Wildcard Filter/search

Post by Alan Kirk »

nimol wrote:Thanks, I guess there is no way you can type in multiple conditions directly into filter by wildcard function?
Unfortunately not.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply