Unable to Fetch Data

Post Reply
bubidibabadi
Posts: 5
Joined: Tue Jul 23, 2019 7:19 pm
OLAP Product: TM1
Version: 10.2.2, PA
Excel Version: 2010

Unable to Fetch Data

Post by bubidibabadi » Mon Mar 23, 2020 7:27 pm

Hello Guys,

One of the user is unable to access the cube A in workspace. They are getting "unable to fetch data. user does not have read access".

Cube A has 3 security groups related to it, lets say Group A, Group B, Group C.

The user has write access to Group A, but is not assigned to Group B and Group C.

I have checked the dimension security as well and all the dimensions in Cube A have read access to all the Groups. Doesn't this mean she should be able to view the cube?

What could be the possible reason why the user is unable to access?

Thank you.

tomok
MVP
Posts: 2702
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Unable to Fetch Data

Post by tomok » Mon Mar 23, 2020 7:49 pm

bubidibabadi wrote:
Mon Mar 23, 2020 7:27 pm
I have checked the dimension security as well and all the dimensions in Cube A have read access to all the Groups. Doesn't this mean she should be able to view the cube?
What about any }ElementSecurity_xxxx cubes, or even }CellSecurity cubes?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Wim Gielis
MVP
Posts: 2366
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: Unable to Fetch Data

Post by Wim Gielis » Mon Mar 23, 2020 11:32 pm

Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

bubidibabadi
Posts: 5
Joined: Tue Jul 23, 2019 7:19 pm
OLAP Product: TM1
Version: 10.2.2, PA
Excel Version: 2010

Re: Unable to Fetch Data

Post by bubidibabadi » Wed Mar 25, 2020 3:58 pm

Thanks a lot for the tomok and Wim! Apparently the issue was in cell security. We fixed it.

Post Reply