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.
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
Picklist FOR (not 'with') element attribute
-
- 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 FOR (not 'with') element attribute
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.
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
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
-
- 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
Picklists work in }ElementAttribute_ cubes.
You just need to create a picklist cube and define a rule for the picklist.
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.
-
- 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
Thank you guys,
It works just fine!
It works just fine!