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
POW workspace specific Picklist
-
- 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
Thanks
Micheline
Micheline
-
- 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
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.
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
-
- 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
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
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
Micheline
-
- 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
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
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