Hi,

I want have a Dimension named Sales Representative and i want to
restrict it such that an employ cannot see members above itself and
cannot see siblings or members other than that come under his
hierarchy. I donot want to restrict top and bottom level i have put MDX
for allowed set which is working fine

Allowed Set:

Generate(Filter(
Filter(
{[Sales Representative].members},
[Sales Representative].currentMember.name <> "All Sales Representative"

),
[Sales Representative].currentMember.Properties("Login") = username
)
, Descendants([Sales Representative].currentMember,[Sales
Representative].CurrentMember.level,After))

but it also shows members that are assendants to the current member All
Sales Representatives, Country manager, national manager but i dont
want a regional manager to see them when i put MDX for dening them

Denied Set:


Except(
Generate(

Filter(
Filter(
{[Sales Representative].members},
[Sales Representative].currentMember.name <> "All Sales Representative"

),
[Sales Representative].currentMember.Properties("Login") = username
)
,Ascendants([Sales Representative].currentMember)
)
,
{Filter(
Filter(
{[Sales Representative].members},
[Sales Representative].currentMember.name <> "All Sales Representative"

),
[Sales Representative].currentMember.Properties("Login") = username
)
}
)

it gives me message that at least one member should be allowd in
dimension.

Can any body help in this regard

Thanx