Add data to the data drop-down list controls

This task adds the required data items to the two drop-down list controls in the report.

Procedure

Right-click the first data drop-down list control and click Go to Query.
Query1 opens in the Query Explorer.
Click the Source tab and do the following:
- Expand the Sales and Marketing (analysis) folder and the Sales namespace.
- Expand the Products dimension and then the Products hierarchy.
- Drag Product line to the Data Items area.
Click Product line and in the Properties pane, do the following:
- Click the Name property, delete the existing name, and type
  Core products
- Double-click the Set Definition property.
- Click the new button and then click Exclude.
- In the Available members box, expand Sales and Marketing (analysis), Sales, and Products.
- Drag the Mountaineering Equipment, Personal Accessories, and Outdoor Protection members to the Members box.
The Core products member set now contains only Camping Equipment and Golf Equipment.
Click OK twice.
Pause the pointer over the page explorer button and click Page1.
Click the Data Items tab and drag Core products from Query1 to the drop-down list box in the control.
Click the control and in the Properties pane, for the No Value List Item property, click Show.
The Properties pane for the no value list item property appears.
Double-click the Label property, type Core products in the Default text box, and click OK.
Right-click the second data drop-down list control and click Go to Query.
Query2 opens in the Query Explorer.
Click the Toolbox tab and drag Data Item to the Data Items area.
In the Expression Definition box, type
children ([Sales].[Retailers].[Retailers].[Region]->[Retailers].[710])

Tip: This expression returns the children of the Americas member. The MUN for Americas is used instead of the member name.
In the Properties pane, click the Name property, delete the name and type
Countries and regions
Pause the pointer over the page explorer button and click Page1.
Click the Data Items tab and drag Countries and regions from Query2 to the drop-down list box in the control.
Click the control and in the Properties pane, for the No Value List Item property, click Show.
The Properties pane for the no value list item appears.
Double-click the Label property, type Countries and regions in the Default text box, and click OK.