TM1 Security rights is all being managed within TM1. Canvas does not maintain this.
Check the access rights of the group that the user belongs to. Usually there is a }Drill_< drill TI process name > behind it.
Please ensure that the user has access to this TI. Afterwards, check also the Source being used by the drill process if the user has access to it. For example, if the drill is towards a Cube, ensure that the user belongs to a group that has a READ access into that cube as a minimum.
Thank you for the feedback. I checked the process security and the cube security. The user has both access to the proper cube and processes. Where I am confused is that it is possible for the user to drill through via Architect but not from Canvas.
Please review the TM1 security settings of the user in accessing the drill through:
Cube Security: }CubeSecurity. If the drill is from Cube A to Cube B so set both cubes as READ. Also check the drill assignment }CubeDrill_ cube security.
Dimension Security: }DimensionSecurity. Check if the user has access to all dimensions in Cube A and B as per example above.
Also chek the drill assignment }CubeDrillString dimension security.
Element Security:}ElementSecurity[element name]. If somehow there is an element security set up. Cell Security of the cube if necessary.
Process Security: }ProcessSecurity. For any Drill process related to the drill-through. }Drill_[drill process name].
I think that’s all. However, if the user is ADMIN everything is ok.
Thank you for your feedback. I rechecked all the security cubes and the user has proper access. I forgot to mention that the drill is from Cube A to a SQL Table.
Again, what is weird is that the drill through works via Architect/Perspective and not via Canvas.