Expand Segment Values
The Expand feature allows you to extract a list of all the lowest level child values that roll up to a particular segment selection. This might be a parent value, range, wild card or a combination of these options. You have the ability to expand in a number of directions – down, up, right and left.
- 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 expand button
- The child values are retrieved from Oracle and are inserted below the selected cell.
You can also highlight a number of columns and GL Wand will insert the child values and copy the contents of the highlighted cells against each child value that is inserted.
- Select a cell that has a segment selection and highlight the number of columns that you would like to have copied into the new rows.
- Choose the relevant segment from the segment list e.g. “Account”.
- Click the expand button
- The child values are retrieved from Oracle and are inserted below the selected cell.
- The contents of the additional columns that were selected are copied against each new row inserted. In the example below this contains a generic Get Balance formula which is then resolved for each child value.
You also have the option of selecting multiple rows when performing an Expand. GL Wand will perform an expand on each selected row.
Undo Expand
Clicking the Undo Expand button will remove the results of the previous expand executed. Multiple undo levels are supported meaning you can click Undo Expand again to remove the previous expand results.