role in cube SSAS in dim EMPLOEE parent-child

• b_slutski

  Newbie

  Points: 5

  More actions

  October 20, 2013 at 11:58 am

  #278199

  Hello

  i want to do role in dim employee parent-child

  than manager can see data for him employees,

  but not can see data about him manager

  i use

  Filter(

  [DimEmployees].[SK EMPLOYEE MANAGER].Members,

  [DimEmployees].[SK EMPLOYEE MANAGER].CurrentMember.Properties("LOGIN USER")=UserName

  )

  but this not work good

  because my manager can see data about him manager

  can u help me? please

  thanks