Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Ragged - Level hierarchy in OBIEE

Received Response
12
Views
2
Comments
Mandy J
Mandy J Rank 2 - Community Beginner
edited Aug 13, 2024 5:56PM in Oracle Analytics Forum

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

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics & AI Strategist

    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
    Mandy J Rank 2 - Community Beginner

    Thanks Robert .