Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: Nilam on 03 Oct 2014 07:44:54 AM

Title: How to use Stored procedure to create package in FM
Post by: Nilam on 03 Oct 2014 07:44:54 AM
Hi Expert,

I have Stored procedure in my DB. How can I create FM package using SP?

Many Thanks  :)
Title: Re: How to use Stored procedure to create package in FM
Post by: Nilam on 06 Oct 2014 01:42:15 AM
Hi Expert,

Please help!!!!

My stored procedure is in sql server DB, and I want to use this for package creation in cognos FM.

Thanks a ton ..:)
Title: Re: How to use Stored procedure to create package in FM
Post by: bdbits on 06 Oct 2014 05:32:44 PM
You do not create packages from a stored procedure. You create a Framework Manager model, then create a query subject based on the stored procedure, and include that when you generate a package(s).

Stored procedures is covered in the Users Guide aka as menu item Help > Contents. If you search on "stored procedure" there is a link to "stored procedure query subjects".

I would also suggest working through the User Guide. It will teach you the essentials including some best practices you should follow when modelling.
Text only | Text with Images