BEx Query Hierarchy Presentation in a Input ready query

Hi All,

We need to display GL Account Hierarchy for a Input ready query in a below manner . Can you please suggest possible options.

We want to display the Parent Sub Node of a Hierarchy followed by one base member .

In the below Example of a GL account hierarchy ,

COST

---> Travel Cost

---- >GL 1

---- >GL 2

---> Simlilarly other costs ... (HR Costs , Training Cost, etc..)

---> Planning

-----> Planning GL 1

We want to display in the below format . Since the planning GL node is part of the parent node, we want to display the top node of Cost for Actuals and enable Planning GL for Input .

Actuals Plan

Cost 1000 1200

Planning GL1 Not input ready 1200

we dont want to disaggregate to all the base level GLs but also show comparison at parent level for actuals vs plan.

Any pointers will be useful.

Regards,
Sridhar Sundaram