OAC Summary-to-Detail Drilldown using Ragged Level-Based Hierarchy

PeteSiekierski

I'm trying to develop a detail report to go with my summary report. Both reports use the same ragged level-based account hierarchy with over ten levels. Most of the action hovers around the 6-9th level, but in theory, this could apply to any level.

What I'd like to do is allow the user to click on any sum in the pivot table and drill into the detail for the given amount. For example, in the screenshot below, a user could drill on the $6,296 total at Level 8 for "Accounts Payable - Late AP" (a leaf node corresponding to account 211115) and see what accounting entries make up that total. He could also click on the $10,355 total at Level 7 for "AP". I would then expect the detail report to show him all of the children under "AP" at Level 7 (they're the eight leaf accounts shown in the screenshot), including the $6,296 for Late AP.

The problem I'm having is linking the two reports. Both reports have the same relationship between the hierarchy and the GL balances, and, if I drill on the balance from a leaf shown on the summary report, it works when I say that Parent Account 8 (and all the other parents above it) "Is Prompted" in the detail report's filters.

However, when I drill on "AP" at Level 7 - which is not a leaf - the detail report returns no data. The summary report has no value to pass for Parent Account 8, and the filter in the detail report insists that the condition is now "Parent Account 8 is null", as shown below. There are eight viable child values for Parent Account 8 in this situation, though, so naturally equating them to null costs me all of my detail.

I've been trying all sorts of ways around this, but I'm coming up short some way each time. Could there be a clever way of looking at data in my hierarchy, or maybe an unlisted function I'm forgetting about that might close my gap?