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

    1608438

      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


      Thanks

      Sai