Add attributes to control dimension
-
- Posts: 124
- Joined: Tue Jun 13, 2017 3:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Add attributes to control dimension
Hi all,
How do we add attributes to a control dimension? I remember to have done it once and it's not working now. Is there a special way to add for control objects?
Thanks,
Paul.
How do we add attributes to a control dimension? I remember to have done it once and it's not working now. Is there a special way to add for control objects?
Thanks,
Paul.
-
- 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: Add attributes to control dimension
A small Turbo Integrator process ?
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
-
- Posts: 124
- Joined: Tue Jun 13, 2017 3:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Add attributes to control dimension
Thanks Wim Gielis.
I want to create a pick list on a control dimension from values in a dimension. Sorry. I should have been clear.
I tried things like below and both don't seem to work.
dimension:dimension_name
subset:dimension_name:subset_name
Thanks,
Paul.
I want to create a pick list on a control dimension from values in a dimension. Sorry. I should have been clear.
I tried things like below and both don't seem to work.
dimension:dimension_name
subset:dimension_name:subset_name
Thanks,
Paul.
- gtonkin
- MVP
- Posts: 1192
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Add attributes to control dimension
If the dimension is used in a cube, have you tried creating a picklist cube then writing the relevant rule against the dimension?
-
- MVP
- Posts: 1815
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Add attributes to control dimension
I seem to recall that in certain versions you needed a picklist cube to be able to add picklists to control dimensions but in other versions you could do it by a picklist attribute. Im not sure which versions it is as for certainty i always use a picklist cube now.
Declan Rodger
-
- 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: Add attributes to control dimension
There is a big difference between creating an attribute and a picklist. In fact the two are nothing alike at all.Paul-TM1 wrote: ↑Sun Apr 29, 2018 5:51 pm Thanks Wim Gielis.
I want to create a pick list on a control dimension from values in a dimension. Sorry. I should have been clear.
I tried things like below and both don't seem to work.
dimension:dimension_name
subset:dimension_name:subset_name
Thanks,
Paul.
Declan is correct. For picklists to work in control cubes you must have a picklist cube. This is true for all versions.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- MVP
- Posts: 1815
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Add attributes to control dimension
There was definitely a version where you could use a normal picklist attribute but if I remember correctly it was something like 10.1 and it was something that hadn't been possible before and then in a later version got removed again, it caused problems with an upgrade I did where the functionality disappeared.
Declan Rodger
-
- Posts: 124
- Joined: Tue Jun 13, 2017 3:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Add attributes to control dimension
Thanks for all the advises. I will try a pick list cube.
Thanks,
Paul.
Thanks,
Paul.
-
- Posts: 124
- Joined: Tue Jun 13, 2017 3:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Add attributes to control dimension
Hi,
One last question. In the rule of pick List Cube, when I tried to add from a dimension, it does not work.
['AcqType'] =S: 'dimension::Attribute-AcqType-All' ;
Static values work.
Can somone help me with this bit of code?
thanks,
Paul.
One last question. In the rule of pick List Cube, when I tried to add from a dimension, it does not work.
['AcqType'] =S: 'dimension::Attribute-AcqType-All' ;
Static values work.
Can somone help me with this bit of code?
thanks,
Paul.
-
- 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: Add attributes to control dimension
Can you describe in words where the picklist values should come from ?
A guess: if Attribute-AcqType-All is a dimension name, then replace :: with :
A guess: if Attribute-AcqType-All is a dimension name, then replace :: with :
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