Using a cascading member filter control

Contents[Hide]

1. Overview

A cascading member filter control displays each level of a hierarchy on separate dropdown controls. Each dropdown is filtered based on what is selected on the parent level dropdown.

Pre-requisites: You need to be using a hierarchy, either from an SSAS Cube, or for relational data - a hierarchy created from the Hierarchy designer. Data used in this sample is based on the Data Cube created from the article Using a data cube to join tables.

2. Setting up the Cascading Control

  1. Drop the measure and the hierarchy to the dashboard.

    Drop the measure and the hierarchy to the dashboard
    Drop the measure and the hierarchy to the dashboard

  2. From the toolbar, add a Cascading Member filter control.

    Add a cascading member filter
    Add a cascading member filter

  3. Connect the filter to your hierarchy.

    Connect the filter to your hierarchy
    Connect the filter to your hierarchy

3. Testing

  1. Select Bikes on the first level dropdown (Product Category level).

    Select first level member
    Select first level member

  2. Click on the second level dropdown. The members listed should belong to the parent level (Bikes). Select Mountain Bikes.

    Select second level member
    Select second level member

  3. Click on the third level dropdown. The members listed should belong to the parent level (Mountain Bikes). Select Mountain-100 Black, 42.

    Select third level member
    Select third level member

4. Result

Result
Result

5. Properties

  • Hide Token Menu: If this is set to true, the token menu will not be displayed on the parameter control.
  • Manual Items: If enabled, the item(s) displayed in the control are manually controlled instead of auto-populated from any associated View Parameters. This is most useful when using this control with script instead of with a parameter.
  • Show Checkboxes: Enable the user to select multiple items. This only applies to the last hierarchy picker.
  • Set Value On Any Filter Change: By default, any controls being filtered by this cascading member filter will only filter when the last filter control gets a value. Enabling this option will cause the control to filter all connected controls whenever any of the filter controls change.
  • Show Search: Show the search bar to enable users to search for specific hierarchy members. This applies to all hierarchy pickers.

6. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri