If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Unbalanced Hierarchy -Help Needed

Started by cognos05, 28 Oct 2020 11:32:52 AM

Previous topic - Next topic

cognos05

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 .


bus_pass_man

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.