check out this link

http://www.mssqltips.com/sqlservertip/1834/introduction-to-dimension-security-in-sql-server-analysis-services-ssas-2005/

this might help

create a cube role say sales unit /sales area against unit / area dimension

then restrict the required dimension to those dimensions

eg US salesmen should have usa units /area ticked...

Can you help me out with the trace .

eg select * FROM sys.sysprocesses

what i need is

loginname - windows user name

hostname - machine where the user connected...