Print Page - Stored Proc in Cognos report studio

Title: Stored Proc in Cognos report studio
Post by: Prajam on 23 Apr 2013 09:33:55 AM

HI guys,

i have a requirement of stored proc. in one of the reports having 5 drill thrus which has to update the values
in next drill thru from parent parent

suppose: consider a query item "type code" having A,B,C.
if A in parent report then change to B in child report
vice versa

can any one tell the procedure for this using stor.proc?

thanks in advance

Title: Re: Stored Proc in Cognos report studio
Post by: blom0344 on 23 Apr 2013 01:33:14 PM

There is no such thing as a SP within a report. Reports simply show the outcome of queries. You can define an SP within the database an to some extend and use it within a Cognos model. I doubt whether SP's that update data are supported, I never had much use for them. Are you by any chance a programmer switching to BI?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Prajam on 23 Apr 2013 09:33:55 AM