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.
