Picklist from Two Dimensions Based on Condition

Post Reply
tm1green
Posts: 22
Joined: Tue Mar 31, 2015 9:54 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Picklist from Two Dimensions Based on Condition

Post by tm1green »

Guys,

Can I have a picklist populated from two other dimensions based on some conditions? For example if condition 1 is true then populate the picklist from dimension A else populate the picklist from dimension B.

Thanks in advance.
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Picklist from Two Dimensions Based on Condition

Post by Wim Gielis »

Yes, create a picklist cube with a rule, rather than a picklist attribute.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply