Print Page - Passing Values from Value promt to multiple queries

Title: Passing Values from Value promt to multiple queries
Post by: Maverick111 on 29 Sep 2014 10:18:50 AM

Hi,

I am new to Cognos and looking for help in building a report in report studio.

I have three Queries which has multiple columns and among them there is one common column in all the three, that common column is the Project Name. I was able to Join all these three queries and arrange the data in a single final query.

In the page explorer I am want to create a value prompt for Project name and pass the user selected value to all my three queries in the backend.

Can someone help me in doing this!!! :)

Thanks in Advance.

Regards,
Prasad

Title: Re: Passing Values from Value promt to multiple queries
Post by: HalfBloodPrince on 30 Sep 2014 12:23:25 AM

simply put a filter in all the quries set usage as opional or in the final query :o :o

Title: Re: Passing Values from Value promt to multiple queries
Post by: Maverick111 on 10 Oct 2014 08:02:23 AM

Thank you :). It worked.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Maverick111 on 29 Sep 2014 10:18:50 AM