TM1 Forum

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

Picklists aren't supported in control cubes - shame

It says so on IBMs page:
http://www-01.ibm.com/support/knowledge ... rol_000123

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.

Hi ,

Pick list will support }COntrol objects but the way creation could be problem

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?

Try ['Tiltakstype'] =S: 'static:Yes:No'; (add single quotes to left side)

Gabor wrote:Try ['Tiltakstype'] =S: 'static:Yes:No'; (add single quotes to left side)

Thanks for your answer. Unfortunalety it did not work.

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)

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
Br
Peter

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.

lotsaram wrote:Walked away from my desk and seems Wim beat my finger to the trigger...

It's good to have a confirmation