* Two columns from the relational source together define the lineage; e.g. Organizational Chart
* “Member Key Column” identifies the member
* “Parent Key Column” identifies the parent
* “Member Name Column” provides the member name to display when browsing the cube
* Identify top-level member: parent = blank, self, or missing
* Set “Root Member If” property to:
- “Parent is blank, self or missing” (default)
- “Parent is blank” – Parent Key Column is null or 0
- “Parent is self” – Parent Key Column = Member Key Column
- “Parent is missing” – Parent Key Column doesn’t exist in Member Key Column
