Picklist as per another dimension

Post Reply
nayitian
Posts: 26
Joined: Wed Apr 16, 2014 11:10 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Picklist as per another dimension

Post 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.
declanr
MVP
Posts: 1831
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 as per another dimension

Post by declanr »

Create a picklist cube as opposed to an attribute picklist.
Declan Rodger
nayitian
Posts: 26
Joined: Wed Apr 16, 2014 11:10 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Re: Picklist as per another dimension

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