Add Storedprocedure query object to a Package

[vamsivanka]

Not able to deploy the changes to the Package in the Framework Manager.


We added a stored procedure to the Framework Manger and compiled successfully.

Selected a Package and clicked on "Edit Definition", Selected the "Query Object" and deployed.

But, it is not showing up when i tried to create the report.

Thank you

[MFGF]

Not able to deploy the changes to the Package in the Framework Manager.


We added a stored procedure to the Framework Manger and compiled successfully.

Selected a Package and clicked on "Edit Definition", Selected the "Query Object" and deployed.

But, it is not showing up when i tried to create the report.

Thank you

Is it defined as a Data Query stored procedure or a Data Modification stored procedure in FM?

If the latter, you don't see it in the package tree. It is only available to be called from Event Studio.

MF.

[cognos810]

Also, in case of a data query subject type for the stored procedure, the SP needs to return at least one column which could be anything like a Dummy value.

-Cognos810