GL Balances to Journals Drill Down at parent/child level

Summary

GL Balances to Journals Drill Down at parent/child level

Content

We have built a Balances analysis in OTBI which can drill down to any level within the 8 segments (company, bu, cc, nominal, etc.) that are defined in our organization.  We have a requirement to drill down from this Balances report to the related Journals of the parent and the child level segment values.  Is there a way to do this? 

Example:

Suppose C1 company has 2 children C2, C3.  The user searches for balances at level C1.  He/she then clicks on the balance amount on that record.  This should open up Journals analysis with journals associated with child companies C2 and C3 (since journals are posted only at child levels).