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.

1. Select a cell that has a segment selection e.g. a parent value.
2. Choose the relevant segment from the segment list e.g. “Account”.
3. Click the expand button
4. 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.

1. 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.
2. Choose the relevant segment from the segment list e.g. “Account”.
3. Click the expand button
4. The child values are retrieved from Oracle and are inserted below the selected cell.
5. 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.

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.