Picklist on Control cube
-
- Posts: 38
- Joined: Fri May 18, 2012 7:06 pm
- OLAP Product: TM1 , transformer
- Version: 9.5 + 10.1 + 10.2 + 10.2.1
- Excel Version: 2010 + 2008
- Location: Sweden
Picklist on Control cube
Hi there
Im trying to create a picklist on a control cube but I must be doing something wrong since the cell im adding the rule to just displays the text static:Yes:No.
The steps im doing it are:
-I have a dimension called Tiltak and want to create a picklist on the controlcube for this dimension
-right click on my control cube, }ElementAttributes_Tiltak, and click on create picklist cube
-This creates a picklist cube }Picklist_}ElementAttributes_Tiltak
-I then create a rule on the picklist cube and write [Tiltakstype] =S: ('static:Yes:No'); (the element [Tiltakstype] comes from the dimension }ElementAtrribute_Tiltak)
-The rule checks out and I then double click the cube }Picklist_}ElementAttributes_Tiltak to open it in Cube viewer
-Then the picklist is just showing the text I wrote in the rule: static:Yes:No
It seems im doing something wrong in the rule so Ive tried [Tiltakstype] =S: 'static:Yes:No'; but it does not work either.
What am i doing wrong here?
Best regards
/Peter
Im trying to create a picklist on a control cube but I must be doing something wrong since the cell im adding the rule to just displays the text static:Yes:No.
The steps im doing it are:
-I have a dimension called Tiltak and want to create a picklist on the controlcube for this dimension
-right click on my control cube, }ElementAttributes_Tiltak, and click on create picklist cube
-This creates a picklist cube }Picklist_}ElementAttributes_Tiltak
-I then create a rule on the picklist cube and write [Tiltakstype] =S: ('static:Yes:No'); (the element [Tiltakstype] comes from the dimension }ElementAtrribute_Tiltak)
-The rule checks out and I then double click the cube }Picklist_}ElementAttributes_Tiltak to open it in Cube viewer
-Then the picklist is just showing the text I wrote in the rule: static:Yes:No
It seems im doing something wrong in the rule so Ive tried [Tiltakstype] =S: 'static:Yes:No'; but it does not work either.
What am i doing wrong here?
Best regards
/Peter
-
- Site Admin
- Posts: 1453
- Joined: Wed May 28, 2008 9:09 am
Re: Picklist on Control cube
Picklists aren't supported in control cubes - shame
-
- Posts: 38
- Joined: Fri May 18, 2012 7:06 pm
- OLAP Product: TM1 , transformer
- Version: 9.5 + 10.1 + 10.2 + 10.2.1
- Excel Version: 2010 + 2008
- Location: Sweden
Re: Picklist on Control cube
It says so on IBMs page:
http://www-01.ibm.com/support/knowledge ... rol_000123
http://www-01.ibm.com/support/knowledge ... rol_000123
-
- 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: Picklist on Control cube
What version are you on. I have used picklists on control cubes in most versions.
10.1 (well some versions of it) allowed picklists on attributes cubes through either an attribute picklist or picklist cube.
But the first iteration of 10.2 I think only allowed a picklist cube driven picklist and the ones done by attributes failed.
If you are on an older version of TM1 e.g. the 9.5 series then you could have issues.
10.1 (well some versions of it) allowed picklists on attributes cubes through either an attribute picklist or picklist cube.
But the first iteration of 10.2 I think only allowed a picklist cube driven picklist and the ones done by attributes failed.
If you are on an older version of TM1 e.g. the 9.5 series then you could have issues.
Declan Rodger
-
- Posts: 5
- Joined: Thu Dec 10, 2015 11:35 am
- OLAP Product: COGNOSTM1, Cognos
- Version: 10.2.2
- Excel Version: 2010
Re: Picklist on Control cube
Hi ,
Pick list will support }COntrol objects but the way creation could be problem
Pick list will support }COntrol objects but the way creation could be problem
-
- Posts: 38
- Joined: Fri May 18, 2012 7:06 pm
- OLAP Product: TM1 , transformer
- Version: 9.5 + 10.1 + 10.2 + 10.2.1
- Excel Version: 2010 + 2008
- Location: Sweden
Re: Picklist on Control cube
Hi
I'm on 10.2.2 so it should work. At least according to IBM
http://www-01.ibm.com/support/knowledge ... rol_000123
Does anyone see any fundamental error I'm doing?
I'm on 10.2.2 so it should work. At least according to IBM
http://www-01.ibm.com/support/knowledge ... rol_000123
Does anyone see any fundamental error I'm doing?
-
- MVP
- Posts: 170
- Joined: Fri Dec 10, 2010 4:07 pm
- OLAP Product: TM1
- Version: [2.x ...] 11.x / PAL 2.0.9
- Excel Version: Excel 2013-2016
- Location: Germany
Re: Picklist on Control cube
Try ['Tiltakstype'] =S: 'static:Yes:No'; (add single quotes to left side)
-
- Posts: 38
- Joined: Fri May 18, 2012 7:06 pm
- OLAP Product: TM1 , transformer
- Version: 9.5 + 10.1 + 10.2 + 10.2.1
- Excel Version: 2010 + 2008
- Location: Sweden
Re: Picklist on Control cube
Thanks for your answer. Unfortunalety it did not work.Gabor wrote:Try ['Tiltakstype'] =S: 'static:Yes:No'; (add single quotes to left side)
-
- 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 on Control cube
Just to confirm, regarding the parts in bold:A.Pete wrote:-The rule checks out and I then double click the cube }Picklist_}ElementAttributes_Tiltak to open it in Cube viewer
-Then the picklist is just showing the text I wrote in the rule: static:Yes:No
you are checking the picklist in the control cube for attributes, not in the picklist control cube, do you ?
Because in the picklist control cube it's obvious that you see a string like that.
Just asking... I never used a picklist in a control cube (at least I don't remember)
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: 38
- Joined: Fri May 18, 2012 7:06 pm
- OLAP Product: TM1 , transformer
- Version: 9.5 + 10.1 + 10.2 + 10.2.1
- Excel Version: 2010 + 2008
- Location: Sweden
Re: Picklist on Control cube
I have to be totally brain dead today. I cant believe i did not check that...Wim Gielis wrote:Just to confirm, regarding the parts in bold:A.Pete wrote:-The rule checks out and I then double click the cube }Picklist_}ElementAttributes_Tiltak to open it in Cube viewer
-Then the picklist is just showing the text I wrote in the rule: static:Yes:No
you are checking the picklist in the control cube for attributes, not in the picklist control cube, do you ?
Because in the picklist control cube it's obvious that you see a string like that.
Just asking... I never used a picklist in a control cube (at least I don't remember)
That was actually it!! Lots of thanks Wim Gielis.
Ill just have to go and hide under a rock now
Br
Peter
-
- 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 on Control cube
Walked away from my desk and seems Wim beat my finger to the trigger....
You want some attribute in the Tiltak dimension to be either Yes or No. The string "static:Yes:No" in }Picklist_}ElementAttributes_Tiltak is exactly what you would expect to see. To see the result of the picklist definition open a view in the }ElementAttributes_Tiltak cube and you will find when you click on a cell in the Tiltaktype column that a Yes/No PickList pops up.
What you are doing wrong is simple. You are looking in the wrong place! The }PickList cube is where you define the picklist, not where you use it.A.Pete wrote: The steps im doing it are:
-I have a dimension called Tiltak and want to create a picklist on the controlcube for this dimension
-right click on my control cube, }ElementAttributes_Tiltak, and click on create picklist cube
-This creates a picklist cube }Picklist_}ElementAttributes_Tiltak
-I then create a rule on the picklist cube and write [Tiltakstype] =S: ('static:Yes:No'); (the element [Tiltakstype] comes from the dimension }ElementAtrribute_Tiltak)
-The rule checks out and I then double click the cube }Picklist_}ElementAttributes_Tiltak to open it in Cube viewer
-Then the picklist is just showing the text I wrote in the rule: static:Yes:No
It seems im doing something wrong in the rule so Ive tried [Tiltakstype] =S: 'static:Yes:No'; but it does not work either.
What am i doing wrong here?
You want some attribute in the Tiltak dimension to be either Yes or No. The string "static:Yes:No" in }Picklist_}ElementAttributes_Tiltak is exactly what you would expect to see. To see the result of the picklist definition open a view in the }ElementAttributes_Tiltak cube and you will find when you click on a cell in the Tiltaktype column that a Yes/No PickList pops up.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- 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 on Control cube
It's good to have a confirmationlotsaram wrote:Walked away from my desk and seems Wim beat my finger to the trigger...
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