Picklist FOR (not 'with') element attribute

Post Reply
wbf
Posts: 12
Joined: Thu Nov 25, 2021 1:09 am
OLAP Product: TM1
Version: 10.2.0
Excel Version: 2013

Picklist FOR (not 'with') element attribute

Post by wbf »

Is it possible to create a picklist for element in }ElementAttribute_dim?
For example, customer dim has string element attribute called 'gender', I want to control the input by allowing only 'F' or 'M'

Its like element attribute of element attribute. I've tried creating a static one. a new dimension was created with name '}ElementAttribute_ElementAttribute_dim' but the dropdown doesn't seem to appear. 8-)

Can't find any info online - the keyword 'picklist' and 'element attributes' yields only ways to 'create picklist with element attribute', not 'creating picklist for element attribute'.

Thanks in advance
Wim Gielis
MVP
Posts: 3103
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 FOR (not 'with') element attribute

Post by Wim Gielis »

Not sure if an attributes cube supports picklists.
Have you tried a real picklists cube ?
Also, a regular cube instead of an attributes cube will do too. It might be a bit rework in your application but it will work fine.
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
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Picklist FOR (not 'with') element attribute

Post by lotsaram »

Picklists work in }ElementAttribute_ cubes.
You just need to create a picklist cube and define a rule for the picklist.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
wbf
Posts: 12
Joined: Thu Nov 25, 2021 1:09 am
OLAP Product: TM1
Version: 10.2.0
Excel Version: 2013

Re: Picklist FOR (not 'with') element attribute

Post by wbf »

Thank you guys,
It works just fine!
Post Reply