I am building a dmr report. I created 3 slicers and when I checked the generated sql, the slicers are missing in the sql. Why is that? obviously the report also does not look like it is filtered by the slicers I created. Any idea why these slicers are not working?
slicers works a little differently from filters.
filter is like taking out the data you do not want, hence you will see the condition in the where clause of your sql statement.
when using slicers, the data is still there but not included in the computation. that is why you don't see the filter in the sql statement.
Right. In my case, the data is not getting filtered at run time also. Not sure where its going wrong.