Explode Tree
The Explode feature will duplicate the current Excel sheet for each of the ChartField values of the selection. Use the notation TreeName:NodeName e.g. ACCTROLLUP:CASH. The colon “:” is a configurable delimiter. System Administrators can set this on the Delimiter Options form.
- Select a cell that has a Tree Node.
- Optionally change the Business Unit in the toolbar dropdown
- Click the Explode button
- All the ChartField values are retrieved from PeopleSoft 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 Tree Node.
- Start with a complete GL Wand report.
- Select the cell in the report that drives the Get Balance formulas e.g. a department Tree Node in the report header.
- Click the Explode button.
- GL Wand will duplicate the worksheet for each ChartField value under the chosen Tree Node.