Page 1 of 1

Add attributes to control dimension

Posted: Sun Apr 29, 2018 5:28 pm
by Paul-TM1
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.

Re: Add attributes to control dimension

Posted: Sun Apr 29, 2018 5:34 pm
by Wim Gielis
A small Turbo Integrator process ?

Re: Add attributes to control dimension

Posted: Sun Apr 29, 2018 5:51 pm
by Paul-TM1
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.

Re: Add attributes to control dimension

Posted: Sun Apr 29, 2018 6:04 pm
by gtonkin
If the dimension is used in a cube, have you tried creating a picklist cube then writing the relevant rule against the dimension?

Re: Add attributes to control dimension

Posted: Sun Apr 29, 2018 6:45 pm
by declanr
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.

Re: Add attributes to control dimension

Posted: Mon Apr 30, 2018 4:46 am
by lotsaram
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.
There is a big difference between creating an attribute and a picklist. In fact the two are nothing alike at all.

Declan is correct. For picklists to work in control cubes you must have a picklist cube. This is true for all versions.

Re: Add attributes to control dimension

Posted: Mon Apr 30, 2018 8:00 am
by declanr
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.

Re: Add attributes to control dimension

Posted: Mon Apr 30, 2018 11:42 am
by Paul-TM1
Thanks for all the advises. I will try a pick list cube.

Thanks,
Paul.

Re: Add attributes to control dimension

Posted: Mon Apr 30, 2018 8:29 pm
by Paul-TM1
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.

Re: Add attributes to control dimension

Posted: Mon Apr 30, 2018 8:57 pm
by Wim Gielis
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 :