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.
Picklist as per another dimension
-
- 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
Create a picklist cube as opposed to an attribute picklist.
Declan Rodger
-
- 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
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.
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.