Explode FICO Object Value Hierarchy
Explode Hierarchy works in the same way as the Explode FICO Object 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
- Select a cell that has a single parent value.
- Choose the relevant FICO Object from the FICO Object list e.g. “Cost Center Group”.
- Click the Explode button drop down, and select Explode Hierarchy All.
- All the values in the Hierarchy are retrieved from SAP 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 FICO Object.
- Start with a complete GL Wand report.
- Select the cell in the report that drives the Get Balance formulas e.g. a Cost Center Group parent value in the report header.
- Choose the relevant FICO Object from the FICO Object list e.g. “Cost Center Group”.
- Click the Explode button drop down, and select Explode Hierarchy All.
- 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.