GEXI Formula

The GEXI formula is used to display the detail results of a query. The results can appear in a single panel, tabbed panel, or worksheet based on options in the user's Spreadsheet Server Settings, and how the drill down function is executed.

1. In Excel, select the cell where the formula is to reside, then, from the Spreadsheet Server Ribbon, select Formula Builder. The Formula Builder panel appears. Select the formula (GEXI) in the Query Formulas tab.
2. Use the following table to enter data in the Formula Builder > GEXI panel:

Field	Description
Query Name	Click the Browse button to navigate to, and, select the query to be executed. Click the SAP Explorer button () to search for, and, select the SAP query (SQ00) to be executed (see SAP Explorer for more information).
Worksheet	Click the drop-down list, and select the worksheet destination for the formula. Defaults to the current active worksheet.
Starting Cell	Select the cell where the formula is to reside (typically, adjacent to the Cell for Value).
Clear/Shift Worksheet	Specify, when inserting data, whether to overwrite existing cell data in the worksheet, clear all cell data in the worksheet, insert the GEXI formula to the target cell with cell references to parameters, or, to insert the GEXI formula in the target cell, then insert parameter columns and rows to the top-left of the existing worksheet data.
Use/Parameter	If applicable, specify or modify the cells containing the query parameters. A maximum of 25 parameters may be selected.



3. Click Insert. The formula is inserted into the cell, and the GEXI indicator (for example, ???) appears in the cell. The true formula (GEXI(...)) can be seen in the Excel formula bar.

Note: The GEXI indicator value is determined by the user's Application Configurator settings.


4. Copy the GEXI formula to the appropriate destination cells.

Note: If the GEXI formula is used in conjunction with data generated through a GEXD formula, and is in an adjacent column, use the Fill Down Column option to copy the GEXI formula to the same number of rows generated by the GEXD formula (see GEXD formulas for more information).


5. To view detail records for the specified query, select the cell containing the GEXI formula, then, from the Spreadsheet Server Ribbon, select Drill Down, or, right-click, and select Spreadsheet Server > Drill Down. The Drill Down panel appears, displaying the detail records for the query, or the data is pushed to a worksheet.