0 Replies Latest reply on Mar 4, 2015 7:36 PM by 1608438

    Approach for Multiple level- based Ragged Hierarchies in a single dimension table OBIEE 11g


      Hi ,

      We have Dim product with three  level  based dimension hierarchies so I have approached with alternate hierarchies with shared child   but as the underlying data is ragged 

      shared child (product key) will not work


      The other option I was looking at is create alias tables for Dim product and create three separate level based hierarchies separately and all the alias tables will be joined to the Fact table.

      Will it have any ripple effect or any issues I need to worry about ?

      Can you let me know for any other solutions on this regard