🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

How to set reportFilter.filter.members for an OLAP source

Sebastian Vercruysse asked on May 8, 2018

I’m trying to create a filter with a few options selected by using the reportFilter object in slice. Similar to this example: 
However, I’m now using an OLAP data source and I can’t get it to work. I changed one of your examples with Adventure Works. I’m trying to filter the Country on Canada:
But as you can see, it doesn’t filter on Canada. The filter shows, but all fields are selected.
Any idea what I’m doing wrong here?
Many thanks!

2 answers

Tanya Gryshko Tanya Gryshko Flexmonster May 9, 2018

Hello, Sebastian,
Thank you for writing to us.
If you replace [Geography].[Country].[Canada] with [Geography].[Country].&[Canada], everything will be displayed as expected. Here is the example: https://jsfiddle.net/kk6ncpp2/1/
To be sure that you have defined members for filter correctly, we suggest configuring report filters via UI. Then you can save the report by clicking Save button in Toolbar and use this report.
Please let me know if you have any other questions.

Sebastian Vercruysse May 9, 2018

Hi Tanya,
That works, thanks. Good tip too!
Kind regards,

Please login or Register to Submit Answer