Limit user from seeing his Colleagues' data

[#1]

Hi,

I have a table named Account Manager (lets call it AM). I need that the administrators can see all of AM names in this dimension, but on the other hand, an account manger is allowed to see only his name, and all the others account managers will get the name "Other AM' (so we conceal the names of the other account managers, but not the data itself).

How can i accomplish this?

Thanks,

Guy

[#2]

First I'd check how osuser() displays, then I'd map user names to the Account Handler names in your script.

Username, AccountHandler

sys\c.j,Chris

Then, on your chart I'd set up your dimension to say if(osuser()=Username,AccountHandler,'Other AM')

This will however group all your account handlers into one row...

[#3]

What i am trying to achieve is a way that when a user log into the QlikView Document, the Account Manger dimension will be actually changed this way:

From:

Account Manager ID	Account Manager Name
1	Guy Dav
2	Yuri Gal
3	Galfend Ami
4	Annand Tiber

To:

Account Manager ID	Account Manager Name
1	Guy Dav
2	Other AM
3	Other AM
4	Other AM

It is importent since i need to use the dimension in a SET ANLYSIS expression, and i beleive that a solution as described above will be suitable for this porpose.

Thanks,