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: 1828
- 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: 3233
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- 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-2025
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-2025
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