Contact Us
Index
Version 20.3
Version 20.4 Version 21.1 Version 25.2 Version 25.3 Version 25.4 Version 26.1 Version 26.2 Version 26.3
Contact Us
Combine Text
Last Refreshed By
Last Refreshed Time
Split Text
Snapshot
Shared Templates Drive
Drive Types
Dropbox
File Server
Cloud Connector
Navigator
Create a File
Delete a File
Edit a File
Open a File
Common Options
System Administrator Options
System Administrator User Options
System Administrator Delimiter Options
System Administrator Configuration Options
System Administrator Server Information
Discover Segment Values
Discover Level
Discover Period Names
Discover Segment Properties
Expand and Explode
Expand Segment Values
Expand Segment Value Hierarchy
Explode Segment Values
Explode Segment Value Hierarchy
List of Values – Create
Account Type
Enabled Flag
Functional Currency
Get Average Balance Summary
Get Balance
Get Balance Options
Multiple Ledgers
Ledger Name
Ledger Set
Next Segment Value
Parent Flag
Period Name
Period Offset
Previous Segment Value
Segment Description
Segment End Date
Segment Tree
Segment Start Date
Drill Criteria Sheets
Drill Criteria – Balance
Drill Using a Saved Template
Edit Template Layout
Save Template Layout
Manage Templates
Other Tools
Clean Template
Create a Template
Template Storage Requirement
Edit a Template
Delete a Template
Hide Zeros
GL Wand User Options

Expand Segment Value Hierarchy

Expand Hierarchy works in the same way as the Expand Segment Values feature except that it will expand using the defined hierarchy. For this option to work your starting cell must contain a single parent value. The child values are expanded in the defined hierarchy and indented to show the various levels in the hierarchy. You can expand the full hierarchy or just one level.

You can use the Hierarchy Level Spans Columns option to have each level of the hierarchy inserted into a separate column rather than indenting the values in a single column. See the GL Wand User Options to change this setting.

Expand Hierarchy All


You can expand hierarchy all in either a down or an up direction.

  1. Select a cell that has a single parent value.
  2. Choose the relevant segment from the segment list e.g. “Account”.
  3. Click the expand button drop down, and click the Expand Hierarchy All option.
  4. The child values are retrieved from Oracle 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 extracts the values one level down, or one level up the hierarchy.