Assign a Query

A query may be created for listing valid values for another query parameter in the Formula Builder, or Query panel 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 or Query 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.