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.
- 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.
