Invalid picklist detected for cube

Post Reply
Chuks
Posts: 30
Joined: Wed Dec 05, 2012 2:18 pm
OLAP Product: IBM Cognos Planning Analytics
Version: 2.0
Excel Version: 2010

Invalid picklist detected for cube

Post by Chuks »

Hi All,
I have a cube with picklist activated, and whenever there is a server restart the picklist stop working. In the Logs there would be a warning, saying that Invalid picklist detected for cube, but no further details.

The rules in the picklist is mostly Static with predefined choices to select in web.

Has anyone faced a similar issue? Please let me know how to fix it.

Thank you!
User avatar
PavoGa
MVP
Posts: 616
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

Re: Invalid picklist detected for cube

Post by PavoGa »

Are you using any of the system control dimensions (}Cubes, }Dimensions, }Clients, etc.)?
Ty
Cleveland, TN
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Invalid picklist detected for cube

Post by jim wood »

Moved to correct forum.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Chuks
Posts: 30
Joined: Wed Dec 05, 2012 2:18 pm
OLAP Product: IBM Cognos Planning Analytics
Version: 2.0
Excel Version: 2010

Re: Invalid picklist detected for cube

Post by Chuks »

PavoGa wrote: Mon Oct 22, 2018 12:34 pm Are you using any of the system control dimensions (}Cubes, }Dimensions, }Clients, etc.)?
In the Picklist rule? No we dont have any of the control dimensions.
ODI
Posts: 3
Joined: Tue Nov 22, 2016 8:38 pm
OLAP Product: Cognos TM1
Version: 10.2.2
Excel Version: 2013

Re: Invalid picklist detected for cube

Post by ODI »

We had to recreate the cube to solve this issue :(
Chuks
Posts: 30
Joined: Wed Dec 05, 2012 2:18 pm
OLAP Product: IBM Cognos Planning Analytics
Version: 2.0
Excel Version: 2010

Re: Invalid picklist detected for cube

Post by Chuks »

ODI wrote: Tue Oct 23, 2018 2:38 pm We had to recreate the cube to solve this issue :(
Yes,every time I recreated the cube after server restart and it worked again but stops when there is a next restart.
Post Reply