Hello All,
TM1 web
Currently we have a menu page in which we use subnm function to show the drop down of Complete org dimension which has active and inactive consolidations and employees under the consolidations. What we want is new drop down in a different web sheet which should show only the selected consolidations and elements which user has selected in the 1st drop down of Menu page.
Is it possible in TM1 active form and also when we look through TM1 web.
Attached is the file for more clear idea.
Thanks,
Aashish
Dynamic drop down
-
- Posts: 9
- Joined: Fri Dec 18, 2015 6:21 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
- Location: LA
- Contact:
Dynamic drop down
- Attachments
-
- drop down issue.docx
- (65.1 KiB) Downloaded 308 times
-
- MVP
- Posts: 2832
- 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: Dynamic drop down
Wouldn't it be nice if the SUBNM function would take an MDX expression as an argument? If it would then what you want to do would be a piece of cake. Unfortunately it doesn't and what you want isn't a piece of cake. There may be other ways but the only way I know to do it is to store the first selection in a cube (using the }Clients dimension) and then have a MDX subset that references the stored value from your cube to pull back the children of the selected element. I recommend reading the Creating Dynamic Subsets in Applix TM1 with MDX - A Primer (http://www.bihints.com/book/export/html/68. More specifically you want to pay attention to the section entitled Username and StrToMember.
-
- Posts: 9
- Joined: Fri Dec 18, 2015 6:21 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
- Location: LA
- Contact:
Re: Dynamic drop down
Thanks a lot.
Aashish
Aashish
-
- Posts: 78
- Joined: Tue Mar 18, 2014 8:02 am
- OLAP Product: TM1, Cognos Express
- Version: 10.2.2
- Excel Version: 2013
Re: Dynamic drop down
Another option would be to create all subsets in the second dimension based on each element in your first dimension.
By using a picklist cube you are now able to use the subset in the second dimension based on your selection in the first dimension.
Although it may not be the best option (especially when you have a very large first dimension), it does work and perform well.
Just make sure to 'hide' the subsets in your second dimension by prefixing them with } so that the users will not see them.
By using a picklist cube you are now able to use the subset in the second dimension based on your selection in the first dimension.
Although it may not be the best option (especially when you have a very large first dimension), it does work and perform well.
Just make sure to 'hide' the subsets in your second dimension by prefixing them with } so that the users will not see them.
-
- Posts: 9
- Joined: Fri Dec 18, 2015 6:21 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
- Location: LA
- Contact:
Re: Dynamic drop down
Thanks pandinus
-
- 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: Dynamic drop down
Talking about dynamic picklist selection, Please have look at below post:
http://bit.ly/1KgTy24 Thanks
http://bit.ly/1KgTy24 Thanks
"You Never Fail Until You Stop Trying......"
-
- Community Contributor
- Posts: 103
- Joined: Mon Sep 05, 2011 11:04 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2010
Re: Dynamic drop down
Or a similar post, showing basically the same thing in an active form!
http://www.infocatasia.com/tm1-tips/inf ... picklists/
http://www.infocatasia.com/tm1-tips/inf ... picklists/