Do you know if you are able to combine a static picklist and a subset picklist?
I currently have something like (subset
month) but I want to add a static option to the list so that users can remove the month by selecting a null option,Jim.
Combining Picklist Types
-
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:
Combining Picklist Types
Guys,
Do you know if you are able to combine a static picklist and a subset picklist?
I currently have something like (subsetmonth) but I want to add a static option to the list so that users can remove the month by selecting a null option,
Jim.
Do you know if you are able to combine a static picklist and a subset picklist?
I currently have something like (subset
month) but I want to add a static option to the list so that users can remove the month by selecting a null option,Jim.
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
-
jstrygner
- MVP
- Posts: 195
- Joined: Wed Jul 22, 2009 10:35 pm
- OLAP Product: TM1
- Version: 9.5.2 FP3
- Excel Version: 2010
Re: Combining Picklist Types
All I can say I also tried to achieve it and the best thing I could think of was to add additional element to dimension and subset. In my case it was a dot '.' that was supposed to be treated as empty.
Obvious enhancement would be to make TM1 accept empty values, but we don't have it for now (at least not in all interfaces, as I think I read somewhere that e.g. in TM1 Web or somewhere clearing picklist cells by users was possible).
Obvious enhancement would be to make TM1 accept empty values, but we don't have it for now (at least not in all interfaces, as I think I read somewhere that e.g. in TM1 Web or somewhere clearing picklist cells by users was possible).