Added stored Procedure is not getting displayed in published package

[MANI-1986cognos]

Hi ,

I have a stored procedure which will update the table. I have added it as right click on Name space --> create --> Query Subject -->Stored Procedure --> Selecte it from DB --> Validate it and then add it.

i didn't maintain presentation layer so this is the final layer i have.

After selecting it in the Package definition and Publishing the same the added query subject is not available in the path in the published package. What could be wrong here.

[CognosPaul]

Does the stored procedure have a return value? If not, try adding a

Code Select Expand


  select
    @@ rowcount as rowCount
at the end.

[the6campbells]

Note that in FM you can denote if a procedure modifies data or is expected to return data (result set).

The former is intended for Event Studio and the latter reporting.

If a stored procedure does not a resultset then it would be used in a reporting package.

More details should be in the documentation