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