PickList not accessible

declanr
MVP
Posts: 1831
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: PickList not accessible

Post by declanr »

Which particular change in security allowed the users to see the picklists?

Was it elementsecurity? dimensionsecurity? etc
Declan Rodger
Venki@1688
Posts: 29
Joined: Fri Mar 23, 2012 10:19 am
OLAP Product: TM1
Version: TM1 9.5.1
Excel Version: 2007

Re: PickList not accessible

Post by Venki@1688 »

The change in the Clients/Groups security made the picklist available for the users. Unless i give the users the Admin rights in the Clients/Groups security for the application, i am not able to access the Picklist using any of the clients login.
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: PickList not accessible

Post by Martin Ryan »

A little old, but an colleague of mine came across this issue and found this solution:
The issue appeared to be that the users have to be given read access to the picklist control cube as well. If there is a picklist control cube involved in the cube and access not given then even the static dimension picklist will not work.
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
DanielKarr
Posts: 1
Joined: Wed May 22, 2013 6:48 pm
OLAP Product: TM1
Version: 10.1+
Excel Version: 2007+

Re: PickList not accessible

Post by DanielKarr »

I was having this issue and found that there had been a picklist cube created at some point. After deleting the cube files and restarting the server it worked as expected.
ffp
Posts: 4
Joined: Thu Jul 07, 2011 4:02 pm
OLAP Product: TM1
Version: 9.4.1
Excel Version: 2003 SP3
Location: Paris, France

Re: PickList not accessible

Post by ffp »

I encountered the exact same issue with a static picklist and finally found that it was a security issue : one of the dimensions of the cube where the picklist was set, had element security set to "READ" for a non admin user. This not only prevents the non admin user to write into the cube but also prevents the picklist to be displayed inside the cube.
There was no cell security cube associated to that cube but, if there was one, I should've checked also the security defined in it.
Post Reply