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
Multiple Wildcard Filter/search
- 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
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
-
- Posts: 20
- Joined: Fri Jun 10, 2011 6:12 am
- OLAP Product: TM1
- Version: 1022
- Excel Version: 2010
Re: Multiple Wildcard Filter/search
Thanks, I guess there is no way you can type in multiple conditions directly into filter by wildcard function?
-
- 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
Unfortunately not.nimol wrote:Thanks, I guess there is no way you can type in multiple conditions directly into filter by wildcard function?
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.