Smart Filter - Not filtering multidimensional cubes, SSAS

[adamGallard]

I am trying to filter using a dimension from SSAS through a gateway as a direct connection, I can see all of my values in my dimension but when I filter using the smart filter nothing happens, I have checked to see if the filter interactions are correct. if I filter using PowerBI's slicer it works fine. I have also tried both 1.2.5 and 1.2.6 neither work.

[danieleperilli]

Hi Adam, sorry for the late reply. Unfortunately, we are currently not able to test and reproduce the issue. Can you try to use our Pro version (you can get a free trial) just to verify that the issue exists also there? Thanks.

[adamGallard]

Yes I can confirm this is the same issue with the Pro version 2.1.0_445120

Adam

[adamGallard]

Hey is there any update on this, I have recently tried 1.2.8 and still have the same issues and my clients want to use your product, I am happy to demo the issue.

I ran the performance analyzer while selecting a filter, and I have pasted the Dax : // DAX Query EVALUATE FILTER( KEEPFILTERS( TOPN( 30002, SUMMARIZE( VALUES('GL School'), 'GL School'[GL School Attribute.UniqueName], 'GL School'[GL School Attribute] ), 'GL School'[GL School Attribute], 1, 'GL School'[GL School Attribute.UniqueName], 1 ) ), NOT(ISBLANK('GL School'[GL School Attribute.UniqueName])) )

ORDER BY 'GL School'[GL School Attribute], 'GL School'[GL School Attribute.UniqueName]

// DAX Query EVALUATE TOPN( 1001, ADDCOLUMNS( KEEPFILTERS( ADDCOLUMNS( KEEPFILTERS( FILTER( KEEPFILTERS( SUMMARIZE( VALUES('GL School'), 'GL School'[GL School Attribute.UniqueName], 'GL School'[GL School Attribute] ) ), NOT(ISBLANK('Measures (Measures)'[Expense])) ) ), "Expense_GL_School_Attribute_UniqueName", 'Measures (Measures)'[Expense] ) ), "Expense", [Expense_GL_School_Attribute_UniqueName] ), [Expense_GL_School_Attribute_UniqueName], 0, 'GL School'[GL School Attribute], 1, 'GL School'[GL School Attribute.UniqueName], 1 )

ORDER BY [Expense_GL_School_Attribute_UniqueName] DESC, 'GL School'[GL School Attribute], 'GL School'[GL School Attribute.UniqueName]

the first query is the smart filter getting all the results to show, and then the second is of a bar visual that should filter but there is no filtering going on!!!

[danieleperilli]

No updates as far as we can't test it. Can you reproduce the issue in a sample report?

[adamGallard]

I have a sample report and login details for you, but I would prefer to send them directly, can you give me an email address to send them to.

[danieleperilli]

Of course: daniele.perilli@okviz.com

[marcosqlbi]

Adam, can you confirm that a regular slicer works in the same situation where you are not able to use Smart Filter?

[adamGallard]

Yes , i can confirm that a regular slicer works correctly in the same situation.

[adamGallard]

thanks for your support, I have raised a support ticket with Microsoft, 120042323002656 I will let you know the outcome.

[adamGallard]

I have been speaking with Microsoft, they have asked for more information on the hidden fields that are needed to allow the filter to work. if you let me know I will pass them on to the support team at Microsoft.

[danieleperilli]

Sorry, Adam, what do you mean? Hidden fields?

[adamGallard]

you sent me an email a few days ago, that states:

The problem seems the following: only the native slicer in Power BI correctly applies a filter to a Multidimensional model. Any custom visual is not able to do that, and we are not able to operate on that because there are additional hidden columns that are not provided to the custom visuals and are required to apply the filter correctly.

We think you should contact Microsoft to ask whether they have plans to support filters over Multidimensional through custom visuals.

Microsoft is asking what the "additional hidden columns" are that you have referenced in your email.

[danieleperilli]

Ok, Marco will reply about this later then.

[marcosqlbi]

Adam, when you connect to Multidimensional then Power BI uses fields with the suffix ".UniqueName" that are not exposed in the Power BI UI and are not made visible to the custom visuals. You can see an example of this syntax in this blog post: http://byobi.com/2017/08/ssas-multidimensional-and-super-dax/

[adamGallard]

Hi, I have had a response from Microsoft to say this is a known issue and is scheduled to be fixed by the end of the year!!! so we will just have to wait and see. Thanks for your support.

[danieleperilli]

Thanks for your feedback!

[adamGallard]

Hey I see the new version of smart filter pro is now working with the issue I had, is there any roadmap for the fix to be applied to the free version? Thanks