Explode Segment Value Hierarchy

Explode Hierarchy works in the same way as the Explode Segment Values feature except that it will explode using the defined hierarchy. For this option to work your starting cell must contain a single parent value. The child values are exploded in the defined hierarchy. You can explode the full hierarchy or just one level.

Explode Hierarchy All

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 Explode button drop down, and select Explode Hierarchy All.
4. All the values in the Hierarchy are retrieved from Oracle Cloud and each one is inserted into a new spreadsheet in the current workbook.

The most logical use of this feature is to Explode a report to get the details of a parent segment.

1. Start with a complete GL Wand report.
2. Select the cell in the report that drives the Get Balance formulas e.g. a department parent value in the report header.
3. Choose the relevant segment from the segment list e.g. “Account”.
4. Click the Explode button drop down, and select Explode Hierarchy All.
5. GL Wand will duplicate the worksheet for each hierarchy value found for the selected parent.

Explode Hierarchy 1 Level

This works in exactly the same way as the Explode Hierarchy All feature above, except that GL Wand will only extract the values one level down the hierarchy.