Creating a Slider from Joined Queries

You can create a slider that contains dimensions from multiple queries if, and only if, the dimensions from the different queries have the exact same boundaries.

To create a slider using a dimension from multiple queries:

  1. Ensure that one or more report type is inserted in the worksheet for the query for which you want to create the slider.
  2. Click Query View and select Dimension View. Notice that the Report Designer tree view is grouped by dimensions rather than by queries. Under each dimension are the queries that contain that dimension. If the dimensions do not contain the same boundaries, multiple sliders will be created to accommodate each of them. For example, if the Market dimension in one query contains a children filter and the Market dimension from another query contains a descendents filter, two Market sliders would be created.
  3. In the Report Designer, select the dimension on which to base the query.
  4. Click Insert button and select Slider to open Member Selection.
  5. Select dimension members, and filters for the slider and click OK.

    The slider is displayed on the sheet.

  6. Optional: To move or re-size the slider, click Design Mode button and then move or re-size.