Expand FICO Object Values
The Expand feature allows you to extract a list of all the lowest level child values that roll up to a particular FICO Object selection. This might be a range, wild card, or a combination of these options.
- Select a cell that has a FICO Object selection e.g. a range or wild card (note that most FICO Object values in SAP are 10 digit strings, so if using a wildcard, the leading zeroes will need to be included e.g. 000040000*)
- Choose the relevant FICO Object from the segment list e.g. “GL Account”.
- Click the expand button
- The child values are retrieved from SAP 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 FICO Object selection and highlight the number of columns that you would like to have copied into the new rows.
- Choose the relevant FICO Object from the FICO Object list e.g. “GL Account”.
- Click the expand button
- The child values are retrieved from SAP 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 Get New GL 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.