1
calling stored procedure dynamically
can any one suggest how can we call stored procedure dynamically, my actual intention i want to display 52 weeks data using a stored procedure, but in data model i don't want to pass any static values, it has to be called dynamically
1 reply
-
Hi Rajramesh,
I'm not sure I understand your question.
Do you mean call a Stored Procedure dynamically from the Discover View? If so, that cannot be done. Stored procedures can only be used to extract data from an underlying data base as part of a Model data flow. In that scenario, you can use variables in your SQL query.
If you want to create a dynamic set of 52 weeks to dis[play in Discover, then use Formulate to create that set in Pyramid, then simply refer to it when required.
Hope that helps.
Ian