Example: Change members on filter change

A web part can be configured to change members upon filter changes. This can be useful when you want a web part to display related members for a selected member in connected Filter Web Part.

 

To accomplish this functionality you have to use the _FILTERTUPLE_.Item(<index>) token in the expression for the dimension. <index> represents the position of the dimension in the connected Filter Selector starting with zero (0) for the left/top most dimension.

 

The Actual Sales web part below is configured to display top 5 children for selected product.

 

Following expression is used for the Product dimension:

TopCount(_FILTERTUPLE_.Item(0).Children, 5, [Measures].[Actual])

 

 

Actual Sales web part displaying child members for member All Warehouse in the left view and child members for USA in the right view.