Print Page - filter problem

Title: filter problem
Post by: gops210 on 25 Feb 2008 05:07:54 AM

Hi all,

I have created a report containing 4 crosstabs from a OLAP cube source,I have a prompt at the top of the report for Quarters

The requirement is that when i run the report should get filtered default for Quarter 4

and when the user selects the propmt say Quarter 3 then it should show Quarter data.
i was not able to put both the filters.

Kindly help me to achieve both the conditions.

Title: Re: filter problem
Post by: Gopinath on 07 Apr 2008 09:24:15 AM

Hi,

I think you might have solved this issue long back, iam posting this b'coz this might help others.

The filter condition should be

if(?Promptparameter? Is Null) then (Quarter = 4) else (Quarter = ?Promptparameter?)

Thanks

Title: Re: filter problem
Post by: Venu_Gollapudi on 09 Apr 2008 07:56:55 AM

Hi,

You will be having a Option called Default in Prompt properties, just set it for Quarter 4, this will work out.

Title: Re: filter problem
Post by: fmtuat on 18 Aug 2008 03:33:09 AM

Quote from: gobinath on 07 Apr 2008 09:24:15 AM
Hi,

I think you might have solved this issue long back, iam posting this b'coz this might help others.

The filter condition should be

Quarter = if(?Promptparameter? Is Null) then (4) else (?Promptparameter?)

Thanks

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: gops210 on 25 Feb 2008 05:07:54 AM