I have a req to create Ragged and Skip level hierarchies for Wrk Ordrs. This hierarchy has 3 lvls of wrk orders and users want to drill from lvl 3 WO -> lvl 2 WO -> lvl 1 WO.
There is no primary key at the detail or at lvl 1 , all there are is Wrk order numbers at each level.I have created level based hierarchy with BMM layer and created a presentation hierarchial column for this hierarchy.
The issue was with incorrect level keys set at each level in the WO hierarchy. Resolved it with the use of surrogate keys created at ETL and configured hierarchy and presentation hierarchical column. Drilldown was previously enabled too. :)