Explode Segment Values
The Explode feature will duplicate the current Excel sheet for each of the child values of the selection.The selection might be a parent value, range, wild card or a combination of these options.
- Select a cell that has a segment selection e.g. a parent value.
- Choose the relevant segment from the segment list e.g. “Account”.
- Click the Explode button
- All the child values are retrieved from Oracle 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.
-
Start with a complete GL Wand report.
-
Select the cell in the report that drives the Get Balance formulas e.g. a department parent value in the report header.
-
Choose the relevant segment from the segment list e.g. “Account”.
-
Click the Explode button.
-
GL Wand will duplicate the worksheet for each child value found for the selected parent.