How to use Stored procedure to create package in FM

[Nilam]

Hi Expert,

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

Many Thanks  :)

[Nilam]

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 ..:)

[bdbits]

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.