Picklist on Control cube

Post Reply
A.Pete
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

Post by A.Pete »

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
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Re: Picklist on Control cube

Post by David Usherwood »

Picklists aren't supported in control cubes - shame :cry:
A.Pete
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

Post by A.Pete »

declanr
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

Post by declanr »

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.
Declan Rodger
ranga
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

Post by ranga »

Hi ,

Pick list will support }COntrol objects but the way creation could be problem
A.Pete
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

Post by A.Pete »

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?
Gabor
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

Post by Gabor »

Try ['Tiltakstype'] =S: 'static:Yes:No'; (add single quotes to left side)
A.Pete
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

Post by A.Pete »

Gabor wrote:Try ['Tiltakstype'] =S: 'static:Yes:No'; (add single quotes to left side)
Thanks for your answer. Unfortunalety it did not work.
Wim Gielis
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

Post by Wim Gielis »

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
Just to confirm, regarding the parts in bold:
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
A.Pete
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

Post by A.Pete »

Wim Gielis wrote:
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
Just to confirm, regarding the parts in bold:
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)
I have to be totally brain dead today. I cant believe i did not check that...
That was actually it!! Lots of thanks Wim Gielis.

Ill just have to go and hide under a rock now :oops:
Br
Peter
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 on Control cube

Post by lotsaram »

Walked away from my desk and seems Wim beat my finger to the trigger....
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?
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.

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.
Wim Gielis
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

Post by Wim Gielis »

lotsaram wrote:Walked away from my desk and seems Wim beat my finger to the trigger...
It's good to have a confirmation ;-)
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
Post Reply