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.
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.
thank for your prompt response--
but still........how to use those pick list (prompt) procedure??
means...how to call/use....
thak you in advance
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.
???
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.