| Usmani 2005-12-24, 7:23 am |
| 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
|