Wednesday, March 28, 2012

Hide Calculations for some users

Hi,

anyone know if it is possible to secure some calculated measures from different users?

I have a calculated field in the cube that I just want to show for one user.

I guess I need to write some MDX in the "Allow reading of cube content" under Edit Cell data when I edit the role.

Someone have any suggestions?

I found a solution! =)

If you want to hide the measure TB this is the code that you write in the "Allow reading of cube content" under Cell Data.

Code Snippet

Not Measures.CurrentMember IS Measures.TB

No comments:

Post a Comment