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
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
Are you talking about Parent-Child hierarchies, where the relationship is recursive? OBIEE supports these natively, see documentation here.