SSAS - Parent Child Dimension

Refer Source: SSAS - Parent Child Dimension - Unbalanced Hierarchy 5

DimEmployee

In it  the Employee &  the Manager is their and Manager is also the Employee. So to know who is the

manager "ParentEmployeeKey" column holds the Manager id  that is the EmployeeKey.

EmployeeKey

ParentEmployeeKey:SelfReferencingFK

All

 -A

  -A

  -abc

-B

-B

Things to Fix.

1. All is on the top, instead choose a Employee. 

Dimension: DefaultMember: Choose One say A

2.Employee Appearing Twice

i.Not in same level - A , it's not right

ii.Same Level : means ( the employee is evaluated at employee level & there are employee reporting )

Fix:Parent Employee Key: properties

Parent - Child

 MemberWithData: NonLeafDataHidden i.fix

 MemberWithDataCaption:*(DirectReports) ii.fix

NamingTemplate:

1.All

2.CEO

3.Account Manager

4.Manager

5.Engineer

6.Staff

note: ISaggregatable:False