Ragged - Level hierarchy in OBIEE

Question

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

Mandy J · Answer

Thanks Robert .

Robert Angel · Answer

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?