Hi



I am looking for one small help which arise recently.Now requirement is

that



1. If Associate = Manager then he should see all Associates (data)

2. If Associate = Assosiate then he should see himself (data)only



I have Associate Dim table which contains

-------------------------------------------------------------

AssociateID--AssociateName--UserType-- LoginName

-------------------------------------------------------------

1 ----Mr. John ---A --john

2 ----Mr. Bill -----M-- bill

3 ----Mr. Gates-- A-- gates

-------------------------------------------------------------

E.g.

If Mr. Bill(Manager) logged in then he can see Mr. John and Mr. Gates

(data)

If Mr. John(Associate) logged in then he can see himself only (data)

If Mr. Gates(Associate) logged in then he can see himself only(data)



User Type = M (Manager)

User Type = A (Associate)



I have created Login Name and User Type member properties to use in
filter

statement given below to get requirement specifed above.

But its not solving my problem becuase each member of the set
specified in

«Set» in filter , returning the set of members that met the search

condition.



I think there is need to improve the filter and condition somehow.

Can you help me to solve this problem.

filter([Associate].[Associate Name].members,

iif(Associate.currentmember.Properties("User

Type")="A",Associate.currentmember.Properties("Log in
Name")=Mid(UserName,

InStr(1, UserName, "\") + 1),[Associate].[All Associate]))



By above filter logged Associate can see himself and Manager also.When

Manager logged in, he can see himself only.Its wrong result.



Regards



PRP


--
Posted via http://dbforums.com