Get Free Trial

report filtering

arnaud desbiens asked on October 17, 2017

Is it possible to pre slice our report object with reportFilters.. I know your exemples show it’s possible with rows, columns and measures. But can you do it with reportFilters like the following:
slice: {
reportFilters: [{ “filter”: { “members”: [“[Dim Date].[Date ID].&[20171017]”] }, “uniqueName”: “[Dim Date].[Date ID]” }]
I really need to pre filter on the report and not on the rows/columns or measures…

2 answers

arnaud desbiens October 17, 2017

Got it, it’s because in SSAS i decided to set attribute hierarchy visible to false for the date id. In analysis service it’s still possible to query with this hierarchy but perhaps flexmonster need it to be visible to be able to use it.

Tanya Gryshko Tanya Gryshko Flexmonster October 19, 2017

Hello, Arnaud,
Thank you for writing. I am glad everything is working fine. Should you have other questions – please let me know.

Please login or Register to Submit Answer