Securing the Cube - Expert Cube Development with SSAS Multidimensional Models - page 275

The final expression is as follows:
Generate (
NonEmpty (
[Employee].[Employee].[Employee].Members,
(
[Measures].[Employee Count],
StrToMember ('[Users].[User].[' + UserName () + ']')
)
), {
LinkMember (
Employee.Employee.CurrentMember,
Employee.Employees
)
}
)
Copying this expression in the Allowed Member set of the parent/child hierarchy
and enabling the Enable Visual Totals option will do exactly what we need. Now,
when Marco accesses the cube he will see this: