Hi Gurus,I have strange situation as I have a large subset and I am trying to filter required element by Filter by Wildcard
option but due to some reason as soon as I select filter by wildcard and put expression *Product* the subset elements disappears and subset get blank.I have also tried %Product% and %*Product*% with no success.In past I have used it with no issues.Thanks
Filter by wildcard issue
-
- Regular Participant
- Posts: 424
- Joined: Sat Mar 10, 2012 1:03 pm
- OLAP Product: IBM TM1, Planning Analytics, P
- Version: PAW 2.0.8
- Excel Version: 2019
Filter by wildcard issue
"You Never Fail Until You Stop Trying......"
- jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Filter by wildcard issue
As long as you are hitting the all button before searching you should be good. If you don't, it will search on the subset there, so if a product is not in that subset you'll get nothing.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Filter by wildcard issue
What Jim Said. If you just open the dimension with the Subset Editor then you get the default subset. If that subset doesn't have any elements that match your search criteria, even though you know there are some in the dimension, then you must click on the All icon BEFORE you do any filtering.
-
- Regular Participant
- Posts: 424
- Joined: Sat Mar 10, 2012 1:03 pm
- OLAP Product: IBM TM1, Planning Analytics, P
- Version: PAW 2.0.8
- Excel Version: 2019
Re: Filter by wildcard issue
Thanks Jim and Tomok.I did selected both All and Expand All buttons before the filter by wildcard option ,I will check again,May be i did somthing wrong ,It is friday,right 

"You Never Fail Until You Stop Trying......"