Assign a Query

A query may be created for listing valid values for another query parameter in the Formula Builder in Excel.

1. Create a reporting query (for example, Northwind Orders.edq) and a lookup query (for example, Northwind Country Lookup.edq).
2. In the Parameters panel, click the Select Query drop-down list for the associated parameter, and select the desired lookup query. Save the parameter and query changes.



3. In Excel, from the Formula Builder panel, when the reporting query is selected, an ellipses button appears for the parameter (for example, Country).  Click the ellipses button to the view results of the lookup query.