Dear visitor, despite all the challenges, our team continues operating at full speed.

We are ready to help with any questions you may have. Please fill out this quick form and we'll get back to you.

Fill the form
Get Free Trial

report filtering

Answered
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

Public
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.

Public
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.
Regards,
Tanya

Please login or Register to Submit Answer