Display Hierarchy Nodes as Text but Values as Key & Text
I have a balance sheet report that is using a GL Account Hierarchy to display the output. I would like for the report to initially display the Hierarchy Nodes with just the text description but the Individual GL Accounts with both the Text & the Key.
I can accomplish this in BEX after the query is executed by right-clicking a node and navigating to G/L Account > Display As > Nodes > Name. The same process in the web takes more time/effort.
Is there a way to set up the query so initially the Hierarchy Nodes have only the Text but the Values below have Text & Key?