Hi Cameron,

I have not come accross that. I have created several information sources and dimensions and can use filters in IFS Business Reporter as it works for other information sources.

From your post I cannot tell what exactly goes wrong in your case.

1. Does the filter in BR work when you apply a filter on light items from the information source? I guess that works fine.
2. If a) works and filters are not applied when you filter on dimension items, I guess something is wrong with the connection between information source and dimension.

Do you know you can find the query that gets prepared for your report in 'Information Sources - Runtime Log’. If you know how to read SQL statement, maybe you can identify from there what is incorrect.

Hi Paul, 

Thanks for the reply, Sorry for the lack of detail on this one. 

I left it generic originally as i seem to be seeing issues in multiple reports related to the filters.

I will try my best to describe the issue i am having in the most recent report. Here is the report description - 

• Report created using an IAL and only has a info source 
• All joins are handled in the IAL and data pulls through fine when run outside of business report
• The report has a repeater on the line 
• Two fields i have an issue with pull through figures but the filter was set at cell level for those two fields and when cross referencing data in the system it seems to have completely ignored the filters I set in business report and just presented data with no filter. 

In some cases the only way I have been able to present the data with the filters i have needed is to add that statement into the IAL and not in business reports. Using a case statement and different field naming conventions. 

So basically my issues is that cell level filtering doesn’t seem to work for my situation and wondered if anyone had come across this before and if it’s just something i am doing incorrectly 

Thanks Again cameron