What is a good way to handle hierarchies in dimension tables

700 views Asked by At

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

1

There are 1 answers

1
Robin Moffatt On BEST ANSWER

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