nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Parent Child relationship configuration

HI all

I had an issue in parent child hierarchy as when I add the hierarchy the tree works fine but when I add the aggregated columns from another table it give me no data to review

I checked the relation many times , but i can't see the error.

I'm Building a parent child hierarchy for "ACCOUNT" table as

Table1 : DIM_Account

Account_Code

ACC_Parent_Code

ACC_NAME

and 2 alias for same table

Table2 : DIM_Account_Details

ACCOUNT_CODE

ACCOUNT_Desc

YEAR

Table3 : Fact_Account_Details

ACCOUNT_CODE

ACCOUNT_DEBIT

ACCOUNT_Credit

So i generated the closure table and create a physical relation as

Fact_Account_Details.ACCOUNT_CODE ---> Account_Hierarchy.member_key

Account_Hierarchy.ANCESTOR_KEY --> DIM_Account.Account_Code

DIM_Account.Account_Code -->DIM_Account_Details.ACCOUNT_CODE

in the BBM

I added a relation between Fact_Account_Details ---> DIM_Account

and dragged column "distance" from acc_Parent_child_hier to LTS_DIM_ACCOUNT

and dragged columns "ACCOUNT_Desc" and "YEAR" from DIM_Account_Details to LTS_DIM_ACCOUNT

Appreciate you support

Find more posts tagged with

Accepted answers

All comments

Did you check the Levels set in the fact table? is it set at detail level for the parent-child hierarchy?

Yes I did. didn't work

Thanks for your replay

Are Levels set correctly also in dimension?

I Found this link. does it mean I need to create an aggregate table to sum the leafs for the upper layers.

OBIEE 11g – Using aggregate tables with Parent-Child hierarchy | OBIEE Blog

Hi, no, your should be able to use the default one.

Is your closure table populated?

I hope this pic shows the issue implementation step

Parent Child.png

any update, I added a pic with the implementation steps

your help is highly appreciated

Hey,

Edit the LTS of Dim_Account and check whether there is a inner join between these tables ( acc hier , acc & acc detail).

Also, Check the SQL that is generated. Physical SQL will give you all you need (whats missing)

Thanks

MM