Page 1 of 1

Picklist as per another dimension

Posted: Mon Jun 16, 2014 3:22 pm
by nayitian
Hello, I have been searching the site but have not been lucky to find the answer.

Here is a cube structure,
Dim1 : Fiscal Year (2011, 2012...2015)
Dim2 : Region (Asia, Europe, North America...)
Dim3 : Measure (Activ_Status, ...)

After coding "subset:MyPicklist:Boolean" in Active_Status atrribute, the rule implements to all years and regions. However, if only region Asia needs pickup list, is this something can be done?

Thanks.

Re: Picklist as per another dimension

Posted: Mon Jun 16, 2014 3:28 pm
by declanr
Create a picklist cube as opposed to an attribute picklist.

Re: Picklist as per another dimension

Posted: Mon Jun 16, 2014 4:06 pm
by nayitian
Thanks.

To you who might look for the same thing, to be more specific,
1 right click the cube to create pick list cube
2 display control objects and locate the picklist cube
3 write a cube rule

It works for me.