POW workspace specific Picklist

Post Reply
mnasra
Posts: 136
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

POW workspace specific Picklist

Post by mnasra »

HI All,

I dont know POW. I am supporting a customer who had another consultant building their POW.
I have a problem. There is a dropdown list on 1 of the measure in POW.
But there is no picklist in the cube. So it must be defined somewhere in POW. I cannot find it.

Also, I tried putting a picklist on that measure (using attributes) . It did not work!!!!!
I put a picklist on another measure of the same cube, it worked in Architect, but did not appear in POW.

I am completely puzzled by POW.
Thanks for ANY help. I will take it.

micheline
Thanks
Micheline
declanr
MVP
Posts: 1815
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: POW workspace specific Picklist

Post by declanr »

PAW doesn't have any special way of defining picklists, it works the same way across all interfaces.

However, in all interfaces, a picklist that is defined via a picklist CUBE (this will show in control objects as }Picklist_<Your Cube Name> ) will always take priority over anything you define with an attribute picklist. So based on what you have said, I expect there is a picklist cube that is defined.
Declan Rodger
mnasra
Posts: 136
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

Re: POW workspace specific Picklist

Post by mnasra »

THANK YOU Declan.
YES, indeed it was a picklist cube. I did not even look at the control cubes, when I did not see a picklist in the attribute.
Shame on me.
Thanks a million
Micheline
Thanks
Micheline
Wim Gielis
MVP
Posts: 3120
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: POW workspace specific Picklist

Post by Wim Gielis »

You might also be Interested to know that the name is PAW instead of POW.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply