COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: krunal on 06 Apr 2017 03:36:54 AM

Title: How to edit or change multiple filters at once
Post by: krunal on 06 Apr 2017 03:36:54 AM
How to edit or change multiple filters at once
Title: Re: How to edit or change multiple filters at once
Post by: BigChris on 06 Apr 2017 03:41:29 AM
In the same report, or across multiple reports?
Title: Re: How to edit or change multiple filters at once
Post by: krunal on 06 Apr 2017 03:45:30 AM
in the same report
Title: Re: How to edit or change multiple filters at once
Post by: Raghuvir on 06 Apr 2017 03:53:17 AM
are you referring to changing the usage properties for the filters ?
Title: Re: How to edit or change multiple filters at once
Post by: krunal on 06 Apr 2017 03:59:21 AM
I have one report with 50 base columns, 22 unions and 11 joins

The filter condition is applied as (current_date-1), now I have to change filter condition as user can select the date as per required.

this filter is applied to all the unions and joins, so how can I change it in one step.
Title: Re: How to edit or change multiple filters at once
Post by: Raghuvir on 06 Apr 2017 04:31:08 AM
Quote from: krunal on 06 Apr 2017 03:59:21 AM
I have one report with 50 base columns, 22 unions and 11 joins

The filter condition is applied as (current_date-1), now I have to change filter condition as user can select the date as per required.

this filter is applied to all the unions and joins, so how can I change it in one step.

you would need to create a prompt for date and then replace the filter condition as (?date?-1). here date will be selected by the user during runtime of the report.

if you want to change all filters at once then you can replace it using the XML of the report, but you need to be very careful while doing that.
Title: Re: How to edit or change multiple filters at once
Post by: krunal on 06 Apr 2017 10:55:23 AM
Thnx Raghuvir