Print Page - Using SQL objects in Report Studio

Title: Using SQL objects in Report Studio
Post by: guthikv on 14 Oct 2011 02:53:45 PM

Hi all,

I am trying to create a report with three sql objects s1, s2, s3. S1 populates first prompt and S2 popluates second prompt and S3 is the report query. I am doing a cascading prompt from S1 to S2 and run the report.All the sql objects hace a simple 'select' statements only. For some reason after selecting S1 it throws an error saying that S2.columnname doesn't exists. Any thoughts how it should be implemented?
I am using Cognos 10.1, Oracle DB.

Thanks.

Title: Re: Using SQL objects in Report Studio
Post by: guthikv on 18 Oct 2011 02:16:41 PM

Anyone ideas??? Did anyone implement the same and have issues?

Thanx

Title: Re: Using SQL objects in Report Studio
Post by: squish88 on 03 Nov 2011 02:57:42 PM

Did you set the cascade source in s2?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: guthikv on 14 Oct 2011 02:53:45 PM