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