How to Capture Highlighted Slicer Results

[JNM]

I am able to capture slicer results using cubeset, but it only works if an item in the slicer is actually selected. Is there a way to capture the results of a slicer when it's not selected, but is filtered? By that I mean if I have a slicer for products A, B, C and a second slicer for Subproducts A1, A2, B1, B2, C1, C2 - when I select "A" in the Products slicer, only A1 and A2 are highlighted in the Subproducts slicer. I would like to capture the highlighted items in Subproducts slicer as individual items, not just "ALL" and without having to "select" them. If this is possible, how is it done?

Thanks.

 

[ImkeF]

Hi,
Dummy-way to do this:
1) Create a new pivot connected to your target slicers or
2) copy your existing pivot and change back slicers connections to target slicers

take “Subproducts” as first field into the rows of this new pivot table (delete all other row fields), take only one measure into the values section: You should end up with your desired slicer selections in the first columns of this new pivot

This works irrespective of how the slicer attributes are connected to each other (sit in a shared set or not).

 

[ImkeF]

Didn't like it?

Proper MDX-way goes via CUBERANKEDMEMBER(CUBESET...: Introducing CUBESET() and CUBERANKEDMEMBER() - PowerPivotPro PowerPivotPro

If it wouldn't be in 1:n-direction, but the other way around or at least 1:1 within a set, you could also use CUBEMEMBERPROPERTY (or the workaround, if you use PowerPivot, where this function is not available: https://wessexbi.wordpress.com/2014/02/16/a-cubememberproperty-equivalent-with-powerpivot/)