Subset Picklist not refreshing

Post Reply
Paul-TM1
Posts: 124
Joined: Tue Jun 13, 2017 3:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Subset Picklist not refreshing

Post by Paul-TM1 »

Hi Gurus,
We are using PA - 2.0.9.5 version.
I have changed a subset list elements - used as a picklist - in a cube and the new values do not showup in architect/Perspectives. Worse is, the old elements show in dropdown up even after I deleted the "subset:Dimension:SubsetName" from edit element attributes and have run out of ideas to fix. Can some let me know if there's a fix for this?

Thanks,
Luther.
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: Subset Picklist not refreshing

Post by declanr »

Check if there is a }picklist cube - if there is, it will take precedence over the attribute picklist setting.
Declan Rodger
Wim Gielis
MVP
Posts: 3117
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: Subset Picklist not refreshing

Post by Wim Gielis »

A generic TI process that I wrote very recently, can be found here:
https://www.tm1forum.com/viewtopic.php?t=16101
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
Paul-TM1
Posts: 124
Joined: Tue Jun 13, 2017 3:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Subset Picklist not refreshing

Post by Paul-TM1 »

Thank you verymuch Declanr and Wim. }picklist cube was the reason.
Also how would I refresh the picklist?

Thanks a ton!
Wim Gielis
MVP
Posts: 3117
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: Subset Picklist not refreshing

Post by Wim Gielis »

Paul-TM1 wrote: Thu Jan 27, 2022 3:51 am Thank you verymuch Declanr and Wim. }picklist cube was the reason.
Also how would I refresh the picklist?
IBM has documentation online:
https://www.ibm.com/docs/en/planning-an ... pick-lists
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