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.
- Create a reporting query (for example,
Northwind Orders.edq
) and a lookup query (for example,Northwind Country Lookup.edq
). - 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.
- 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.