Webi Query Filters

[Former Member]

I have an existing Webi document with multiple report  tabs and it has 4 query filters . Now I have a requirement as following:

A) tab1 needs to have all the 4 query filters

B) tab2 needs to have only 3 query filters

C) tab3 needs to have all the 4 query filters.

Could anybody please let me know to accomplish this.

Thanks in Advance.

[former_member198519]

See which are the common query filter which you can apply directly on the query itself.

Rest all the filters needs to be handled on the report tabs individually as a report filter. (just a word of caution, it can have performance impact as well to the report)

[amitrathi239]

how is your data in your reports tabs?e.g in first tab are you displaying data from all four queries or from one or two query?

if you are displaying data from all queries then you are getting filtered data only in the tab.

[Former Member]

Hi Amit,

The Webi document has many report tabs with data from one query and when the query was created four filters were applied at the query level.

Is there anyway that I can override one of the filters for  some  tabs.

Thanks

[amitrathi239]

Webi query filters you can not override in the reports tabs.other option is remove the filter from webi query and when required applied on the report tabs.

Before doing this make sure if your are going to remove the filter from query level it may impact the performance. The reason is you are going to get the extra records in the webi report.