COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: pali on 26 Sep 2006 01:01:03 AM

Title: How do you use stored procedures & functions ReportNet?
Post by: pali on 26 Sep 2006 01:01:03 AM
Hi Guys,

I need help in the reportnet using DB2 stored procedures.
Please provide me step by step after importing stored procedures/functions in the FM and aldo how do you use in the report studio.
Thanks in Advance.

Title: Re: How do you use stored procedures & functions ReportNet?
Post by: BIsrik on 10 Nov 2006 01:43:15 AM
Plz refer the manuls for step by step procedure.. :D

Srik
Title: Re: How do you use stored procedures & functions ReportNet?
Post by: maya_sekar on 14 Nov 2006 11:43:17 PM
In Framework manager you have option for importing Stored Procedures and functions. The imported SP's will appear in report studio like any other table.

If you have any input parameter then after importing the Sp's you will have to double click the parameters and give
macro functions like below
#prompt('Start_Date','DATETIME')#

If you give macros then when you run the report with SP's the report will prompt for inputs.