GPXI Formula

The GPXI formula displays the expanded details of a business view in the Drill Down panel.

See Business View Formulas to learn how to access the GPXI panel.

1. Use the following table to enter or modify data in the GPXI panel.

Field	Description
Name	Select the required business view. Business views are available based on user permissions. Use the drop-down menu to select the business view. Click Browse to open the Select Business View panel which retrieves a list of all the business views from Angles within Excel. Search by text. Search by tags. Select the checkbox against the tag(s) in the drop-down menu and click Apply to filter the list. Click Expand All to view all business view descriptions or click the expand icon against individual business views. Select the radio button to use that business view. Click the refresh button to load any newly added or assigned business views.
Sheet	Select the worksheet destination for the formula. Defaults to the current active worksheet.
Starting Cell	Enter the starting cell for the template.
Clear/Shift Worksheet	Choose to clear the entire worksheet, overwrite the existing data, shift the existing data, or overwrite with parameters when inserting the value.
Parameters	Displays the list of columns based on the selected business view. Select the Select All checkbox to include all the columns or deselect the checkbox to exclude the columns from the formula. To select specific columns, select the checkbox against the columns. Note: If you select more than 125 parameters, an error message displays the number of parameters exceeding the limit that you must deselect. Choose to view the details in a row or column. You can use the following filters in the Value field against a column to display specific records: Enter [value] to retrieve a single value. Use * to retrieve all the values. Use [value]* to retrieve values starting with that value. Use *[value]* to retrieve values containing the value. Use [value].[value] to retrieve values within a range. A one-year time range filter displays in the first row by default. Use [value],[value] to retrieve the list of values. Use /[value] to exclude a value. Use ^[segment] to retrieve values in a segment list. Use <[value] to retrieve values greater than that value. Use >[value] to retrieve values less than that value. Use <=[value] and >=[value] to retrieve values that are equal to and greater than or equal to and less than that value respectively.



2. You can perform one of the following actions:
   1. Click Preview to view the first twenty records of the parameters included in the business view in the Drill Down window based on the applied filters. You must select a business view in the Name field to use this function.

   

   2. Click Insert or Update to run the formula. The GPXI indicator displays in the cell.

Note: The GEXI indicator value set in Application Configurator > Application Settings > Query remains the same for the GPXI formula.



3. To use the GPXI formula in conjunction with the data generated through the GPXD formula, copy the GPXI formula to the appropriate destination cell in the adjacent column of the GPXD results grid.
4. Select Execute Reports from the Spreadsheet Server ribbon. The Fill Down Column option configured in the GPXD panel copies and fills down the GPXI formula to match the number of records in the grid.
5. To view detailed results, select the cell containing the GPXI formula and then select Drill Down from the Spreadsheet Server ribbon or right-click and select Spreadsheet Server > Drill Down. The Drill Down panel displays the information.