What is a good way to handle hierarchies in dimension tables

Question

Is there any good approach for designing dimensional table/tables for hierarchical data (similar to employee-manager relation) with inconsistent deep level hierarchy.

Thanks, Ravi

Answer 1

Are you talking about Parent-Child hierarchies, where the relationship is recursive? OBIEE supports these natively, see documentation here.