Hi Experts,
This is how my data looks .
ProductKey Level5 Level4 Level3 Level2 Level1
Product1 10 10-1 10-1-100 10-1-100-000 10-1-100-000-000
Product2 10 10-1 10-1-101 10-1-101-000 10-1-101-000-000
101_H 10 Null Null Null Null
In an unbalanced Hierarchy is it possible to show
10 ->
10-1
101_H
Put the item key as a lowest member under Level1 .
I am getting an error saying null has more than 1 parent for the last row .
How do we handle this .
I think you want to model this as a regular dimension rather than a parent-child. Just out of curiosity, and this will circle back to the patterns which I mention later on, would it be easier and reflect reality if it was modelled as a parent-child dimension?
Are modelling it as this hierarchy
Level5
Level4
Level3
Level2
Level1
ProductKey
Or as this?
Level5
Level4
ProductKey
The pattern and the data suggests a ragged hierarchy rather than an unbalanced hierarchy.
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cog_rlp.doc/c_unbalanced.html
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cog_rlp.doc/c_ragged.html
You don't mention what your experiences with trying the padding member settings is.
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cog_rlp.doc/c_padding_in_hierarchies.html#paddingmembersinhierarchies
No matter what, I would suggest you clarify what hierarchy pattern is in the data and what the data actually represents. The latter really will drive the modelling decision. It might be that it is a unbalanced hierarchy, in which case the modelling actions would need to reflect that.