Execute a Query

Once all fields have been selected, and added to the Field List grid, it is recommended to run a test, to verify the query setup.

Execute a Single Query

1. From the Query Designer Ribbon, select Home, then, select the appropriate Execute Query function. The Result Viewer panel appears, displaying query results, based on the option selected.

Note: A similar panel is also displayed when a drill down is performed on a GEXQ or GEXI formula in Excel.

Execute Multiple Queries

1. From Query Designer, open the first query, then, from the Query Designer Ribbon, select the appropriate Execute Query function. The Result Viewer panel appears, displaying query results based on the option selected.
2. Leave the Result Viewer panel open, and, navigate to the Query Designer landing page.
3. Open the second query, then, from the Query Designer Ribbon, select the appropriate Execute Query function. A new tab appears in the open Result Viewer panel, displaying query results based on the option selected.
4. Repeat steps 2 and 3 as necessary.

Tip: Right-click to select all cells in Result Viewer.