Securing Your Data in Analysis Services - Professional SQL Server Analysis Services 2005 with MDX - page 1008

strtomember
("[Employee].[login].[login].&["+username+"]")),
post).item (0).item (0).parent.datamember is
hierarchize (exists ([Employee].[Employee].members,
strtomember
("[Employee].[login].[login].&["+username+"]")),
post).item (0).item (0),
hierarchize (exists ([Employee].[Employee].members,
strtomember
("[Employee].[login].[login].&["+username+"]")),
post).item (0).item (0).parent,
hierarchize (exists ([Employee].[Employee].members,
strtomember
("[Employee].[login].[login].&["+username+"]")),
post).item (0).item (0))
).item (0)
, employee.employee.currentmember))
> 0 ) or
(strcomp (employee.employee.currentmember.properties
("login"),username) =0),
// Value 1
( count (intersect (
descendants (
iif ( hierarchize (exists
([Employee].[Employee].members,
strtomember
("[Employee].[login].[login].&["+username+"]")),
post).item (0).item (0).parent.datamember is
hierarchize (exists ([Employee].[Employee].members,
strtomember
("[Employee].[login].[login].&["+username+"]")),
post).item (0).item (0),