TM1 Forum

Hi Experts,

Please guide me how to set a default value in Picklist.


Thanks in advance

User Dilip (http://www.tm1forum.com/memberlist.php? ... le&u=10665) is your friend?

In any case, please read this topic and especially, Alan's comment:
http://www.tm1forum.com/viewtopic.php?f ... 490#p42490

Vins,

Picklists in essence just work as data validation methods, they have no ability to actually put a value in a cell without user interaction. As such, all picklist cells will still be empty as standard unless you have put something in them.

What you could do is use a TI to populate all the cells as a starting point with a value, possibly use a second attribute as a "default_picklist" or perhaps a more detailed control cube if you need your default values to be more flexible based on the cube structure.

And be careful to not run the TI once users have already input values in order to avoid overwriting their data. However you could use an IF statement to only overwrite values that are empty/zero.

Thanks Declan !!!

Can you please explain a bit more how to use a default_picklist attribute to attain it?