cancel
Showing results for 
Search instead for 
Did you mean: 

Handling Orphan Nodes in Parent Child Hierarchy

Former Member
0 Kudos

Hello Experts,

We have created a Profit Center Parent Child Hierarchy in the calculation View after joining the transaction table with the parent-child profit Center table through a right outer join.( Other joins dont work at all)

Now how to handle two things:

a) When you have blank PC in the transactional data, then how to deal with this so that it blank profit centers goes to something like NOT ASSIGNED node as in BW, so that we don't miss transactional data ?

b) When you have new PC in the transactional data which is still not there in the PC hierarchy, then how to deal with this so that these new profit centers again goes to something like NOT ASSIGNED node as in BW, so that we don't miss transactional data ?

FYI: We are on SPS6.

Really appreciate your help here.

Thanks & regards,

Jomy

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Experts,

Really appreciate your response on this.

Thanks & regards,

Jomy