Ragged - Level hierarchy in OBIEE

Mandy J

Obiee version - 12.2.1.1.0

o/s                 - Linux x86-64

I'm trying to develop a Ragged - Level hierarchy using our cost center data for our headcount activity. The issue is , there could

be duplicate values in these generations in certain cases and there is no other column that I could possibly add to make it unique .

I've attached a screen shot of how the hierarchy looks like. Would like to know what needs to be done or do I need to structure

the underlying data for a parent-child hierarchy.

Thanks,

Mandy

Robert Angel

This is not a problem with level based hierarchy, I have implemented similar with similar data 'challenges'.

Note, parent / child is more restrictive than level based.

Note, level based is generally okay as long as you have more members going down the hierarchy at each level.

Hope that clarifies?

Mandy J

Thanks Robert .