calling Prompt(pick list) stored procedure..????

[pooja]

how to call propmt procedure in report stored procedure????????? ???

here are the explanation--

-we have 7- stored procedure for 7-different reports.
-ALSO we have other 8-different procedure for prompt value(pick list)
-Now QUESTION is HOW to call/use these pick list(prompt) procedure in report procedure.

please kindly & greatly thank you in advance.

[CognosPaul]

In framework manager, when you define the stored procedure, put prompt macros in all of the parameters for the SP.

So if your SP is something like sp_SalesReport('Year','Region') you would set up

#prompt('Year','integer')# in the year area and
#prompt('Region','string')# in the region area.

In the prompt page in RS you would simply create a value prompt with those same parameter names. Cognos will then pass the selected values for Year and Region to the SP as expected.

[pooja]

thank for your prompt response--

but still........how to use those pick list (prompt) procedure??
means...how to call/use....

thak you in advance

[pooja]

sorry  ....for asking again............

we have diff stored procedure for report and.....diff procedure for prompt (picklist).....

so how to call/use those prompt procedure in report ....

thank you again so much in advance.

[pooja]

 ???

[CognosPaul]

In order to use a stored procedure you need to first import it as an object into framework manager. If the procedure doesn't need any arguments you can use it almost like a regular query. Just import it, include it in the package, and pull the data as normal.

If the stored procedure has required arguments you can put a prompt macro into the Value column for each argument. You can then create a value prompt (with the source data being the previous stored procedure) with the parameter name being whatever you put in the prompt macro.