Call Stored Procedure
How to call Stored Procedure from SQL Server Source with dynamic parameters values to Stored Procedure?
Hi mangesh desai
I'm not sure what you mean by 'Dynamic Parameters'
But this is how you would run a parameterized stored procedure in Pyramid ETL.
This is the SP in SQL,
And this is how to call it from Pyramid,
I hope this helps,
Yakov Shaul mangesh desai i have @year and @weekno as parameters in my SP in this case how can i call SP, here i want to display 52 weeks info of any year, could u suggest
Your approach makes no sense. If you want to display a limited set of data in a query, use slicers and query parameters on an existing data base via a data model (direct or otherwise).
Under this approach, a stored procedure doesn't work - because its a lousy way to query a database dynamically. (Don't confuse this with other technologies that offer dynamic parameterization of the direct source. This is a weak work around to what should be executed directly from the Discover queries using slicers).
If you extract the data via a stored procedure - then query and filter as prescribed above.
Avi Perez tanq for ur response, let me know one thing i want to display week numbers from 1 to 52 in dimension hierarchy but not manually, when i run my report week numbers should be displayed in sequential order suggest with any sample code