TM1 Forum

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

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.

What should i look in those two cubes?

Something specific to concentrate?

Thanks

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.)