WebI Filter

[Former Member]

Hi There

I have a WebI report, one column includes some NULL value, if I add filters to the report, those NULL value records will not be shown up, however, if I add same filter to the block, those records will show up

what is the difference between filter with block and filter with report?

thanks

[Former Member]

this report includes multiple tabs with different queries(but most of them dimension are the same), after un-merged dimension, the issue solved.

[Former Member]

My this report has 5 tabs, for each tab I use different filter to get the correct data, for example, tab1 only show Year 2009 data, tab2 only show 2010 data, ...etc

and each of them only has one table block, normally I add filter at report level for each tab, but one of tab had this issue, so I tried to add the filter to that table block, solved the issue, but I want to understand why this happened?

If I understand correctly, if a report only has one block, no matter if you add filter to the report or add to the block, it should be the same, rigth?

[Former Member]

Its really strange why this is happening.

Because report level filter, filtered the value for all the block/ column under that particular report.

Bock level filter, filtered the value on that particular block and all the column under that block.

Column filter is only for that particular column.

I guess might be some filter ambiguity is happening in your report. Please just check all the filter which you are applying on Report level > Block level> column level.

Hope I understand your situation correctly.

[Former Member]

Hi Cleo,

Block filter will only be applied to the block. Did you select the right object before you put in the block filter? Report filter will be applied to the report, so any data objects (table, graph) in that report will have it's data filtered.

Hope i understand your question correctly.