Drill Through not working for endusers

Post Reply
Gilly
Posts: 2
Joined: Thu Feb 06, 2014 2:56 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Drill Through not working for endusers

Post by Gilly »

Hello Everyone

Background: I have created application in contributor in tm1 10.2. I have utilized control dimension (forecast calculation dimension) in that application.

Que: I have created drill through relational database through SQL. It is working good for admin users but not working for users. When i applied data admin rights to users than they were able to do it. According to me,there is some security issue which not allowing user to access drill down. When user click on drill applied cell than they r not getting drill option. When data admin rights are assigned to them they are able to do so.

drill rules: [' Actual Current Year','Jan']=S:'ABC';

Here Actual Current Year is from forecast calculation dimension which is applied as control dimension in the application.

Let me know ASAP if you had experienced same issues in tm1 10.2

Regards

Being Human
Andy Key
MVP
Posts: 352
Joined: Wed May 14, 2008 1:37 pm
OLAP Product: TM1
Version: 2.5 to PA
Excel Version: Lots
Location: Sydney
Contact:

Re: Drill Through not working for endusers

Post by Andy Key »

If it is working for Admins and Data Admins, but not for non-Admin users, then you need to start by looking at the security settings on the }CubeDrill cubes and }Drill processes.
Andy Key
Gilly
Posts: 2
Joined: Thu Feb 06, 2014 2:56 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Re: Drill Through not working for endusers

Post by Gilly »

What should i look in those two cubes?

Something specific to concentrate?

Thanks
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Drill Through not working for endusers

Post by lotsaram »

Gilly wrote:What should i look in those two cubes?

Something specific to concentrate?

Thanks
For a good reason. For drill-through to work the end users must have read access to the }Drill_ processes. (They don't need access to the drill cubes.)
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Post Reply