TM1 Forum

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

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.

Thanks a lot.

Aashish

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.

Thanks pandinus

Talking about dynamic picklist selection, Please have look at below post:

http://bit.ly/1KgTy24 Thanks

Or a similar post, showing basically the same thing in an active form!

http://www.infocatasia.com/tm1-tips/inf ... picklists/