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

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

sql

HELP: Connecting to a secure file share using DTS

I have a dts package that works in connecting to a secure file share when I run it manually. When I schedule it to run on its own - it fails due to the lack of a log on. Is there something I can do to initiate the log in via the schedule rather than me manually doing it ?

Thank you!

When you run it manually, it's executing under your security context. When you schedule it, it will run under the security context of SQL Server Agent service account if the job is owned by a sysadmin. You need to grant the SQL Agent service account permissions to the share. The following article explains this issue:

INF: How to Run a DTS Package as a Scheduled Job

http://support.microsoft.com/kb/269074

-Sue