Expand Tree Hierarchy
Expand Hierarchy works in the same way as the Expand Tree feature except that it will expand using the defined hierarchy. For this option to work your starting cell must contain a single Tree Node value. Tree Nodes must use the notation TreeName:NodeName (e.g. ACCTROLLUP:CASH). The colon “:” is a configurable delimiter. Wands System Administrators can set this on the Delimiter Options form. The tree nodes and ChartField values are expanded in the defined hierarchy and indented to show the various levels of the hierarchy. You can expand the full hierarchy or just one level.
Expand Hierarchy All
- Select a cell that has a single Tree Node value.
- Click the expand button drop down, and click the Expand Hierarchy All option.
- The leaf values are retrieved from PeopleSoft and are inserted below the selected cell in the defined hierarchy.
Expand Hierarchy 1 Level
The Expand Hierarchy 1 Level feature works in exactly the same way as the Expand Hierarchy All feature above, except that GL Wand will only extract the values one level down the hierarchy.