Conditional Pick Lists

[KaneHenderson]

Hi,

I was wondering if it is feasible to have a dynamic picklist selection based on another picklist cell.

For example, if we have a picklist that has x / y / z and another picklist containing a / b / c / d / e. I'm looking to form a relationship between the two as follows:

IF Picklist 1 is X then picklist 2 would have a / b
IF Picklist 1 is Y then picklist 2 would have c and
IF Picklist 1 is Z then d / e

I'm trying to do this to avoid incorrect data mappings, rather than having Picklist 2 having a / b / c / d / e.

Thanks in advance for any support!

[Wim Gielis]

Hello

Did you try Google on:
TM1 dependent picklists

[KaneHenderson]

Hi Wim,

Thank you for this. It really helped me to understand more about using picklist control cubes.

I've wrote this rule for one of my picklists:
['Tableau Sub-Function Level 1']=S:IF(DB('74 MDM Tableau - Entity and Cost Centre W Locations',!070 MDM - Tableau Reporting Log List,'Tableau Function')@='EXECUTIVE','subset: 018 Main - Sub-Functions: EXECUTIVE Function',
IF(DB('74 MDM Tableau - Entity and Cost Centre W Locations',!070 MDM - Tableau Reporting Log List,'Tableau Function')@='FACILITIES','subset: 018 Main - Sub-Functions: FACILITIES Function',
IF(DB('74 MDM Tableau - Entity and Cost Centre W Locations',!070 MDM - Tableau Reporting Log List,'Tableau Function')@='FINANCE','subset: 018 Main - Sub-Functions: FINANCE Function',CONTINUE)));

It quite bizarrely works for some lines in my log, but not others. For example:

Where Tableau Function is EXECUTIVE, the picklist populates on line 10 of my log
Where Tableau Function is EXECUTIVE, the picklist doesn't populate and remains as a string data entry value, almost as if the rule doesn't hit the cell.

[Wim Gielis]

Hi Wim,

Thank you for this. It really helped me to understand more about using picklist control cubes.

I've wrote this rule for one of my picklists:
['Tableau Sub-Function Level 1']=S:IF(DB('74 MDM Tableau - Entity and Cost Centre W Locations',!070 MDM - Tableau Reporting Log List,'Tableau Function')@='EXECUTIVE','subset: 018 Main - Sub-Functions: EXECUTIVE Function',
IF(DB('74 MDM Tableau - Entity and Cost Centre W Locations',!070 MDM - Tableau Reporting Log List,'Tableau Function')@='FACILITIES','subset: 018 Main - Sub-Functions: FACILITIES Function',
IF(DB('74 MDM Tableau - Entity and Cost Centre W Locations',!070 MDM - Tableau Reporting Log List,'Tableau Function')@='FINANCE','subset: 018 Main - Sub-Functions: FINANCE Function',CONTINUE)));

It quite bizarrely works for some lines in my log, but not others. For example:

Where Tableau Function is EXECUTIVE, the picklist populates on line 10 of my log
Where Tableau Function is EXECUTIVE, the picklist doesn't populate and remains as a string data entry value, almost as if the rule doesn't hit the cell.

Hello

Please make sure that all subsets exist, as public subsets in the respective dimensions.
They can be static or dynamic, doesn’t matter.
It’s a bit odd that sometimes you use no spaces, sometimes you use 2 spaces in front of a dash, …
I don’t put a space after the colon in the picklist definition but probably it will work too with a space.