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
Quote from: vamsivanka on 23 Apr 2015 04:21:59 PM
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.
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