Author Topic: Unbalanced Hierarchy -Help Needed  (Read 426 times)

Offline cognos05

  • Statesman
  • ******
  • Join Date: Apr 2014
  • Posts: 756
  • Forum Citizenship: +1/-1
Unbalanced Hierarchy -Help Needed
« on: 28 Oct 2020 11:32:52 am »
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 .


Offline bus_pass_man

  • Statesman
  • ******
  • Join Date: May 2008
  • Posts: 480
  • Forum Citizenship: +45/-0
Re: Unbalanced Hierarchy -Help Needed
« Reply #1 on: 15 Nov 2020 12:13:41 pm »
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.