Scrambling fields for AccessPoint

[#1]

Is there any way to scramble fields for certain users in access point for a qvw without having to create a separate qvw?

[Anonymous]

We scramble based on user id and through a marco that is kicked off via  'on open'.

The code we use in the Macro is basically:

     ActiveDocument.ScrambleField."EnrolLastName", false

The macro code is specific to our environment, but you should be able to come up with a solution.   We basically have a list of UserId's with Flags as to whether certain information should be scrabled for each user.

JS

[#3]

Where are you using the macro?

[Anonymous]

In the analytic that you are trying to restrict / Scramble data.