Using a cascading member filter

Contents[Hide]

1. Overview

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

Pre-requisites: In order to take advantage of separate dropdowns for each hierarchy level, you need to be using a hierarchy with multiple levels. These can be created from the main menu or in an OLAP cube. 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 filter

Select the multi-level hierarchy along with other data in a metric set on the dashboard.

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

From the toolbar, add a Cascading Member filter.

Add a cascading member filter
Add a cascading member filter

Connect the filter to your hierarchy.

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

3. Testing

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

Select first level member
Select first level member

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

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 option is selected, the triangular token menu button will not be displayed.
  • Manual Items: If enabled, the item(s) are manually controlled instead of auto-populated from your data. This is most useful when using this control with script instead of with a parameter, and does not apply when connected to a view parameter and hierarchy.
  • 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 visualizations affected by this filter will only update when a value is chosen in the last dropdown. Enabling this option will cause the visualizations to update whenever any of the dropdowns change.
  • Show Search: Show the search bar to enable users to search for specific hierarchy members. This applies to all dropdowns.

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