Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Exprets,
I'm looking for some assistance on below issue.
1. I'm trying to Execute SQL stored procedure from QlikView. example: SQL EXECUTE [xxx].[StoreProcedureName] '$(vStartDate)', '$(vEndDate)'
2. The particular stored proc have multiple temp tables with the SP.
3. The Data is not populated when I execute from QlikView.
4. But I can execute the same SP from SQL with the given parameters.
My question is Can I simply execute the SP in Qlikview or do I've only option to convert complete query into Qlikview. the reason its not a simple SP(around 400 line code)
please suggest me the solution
This is most likely due to the Edit Script settings needing to be tweaked, you have to Allow the Execute there, see the attached screenshot.
Here is an article regarding running things via Publisher or Reload Engine as well, similar tweak that needs to be made in that case too:
https://support.qlik.com/articles/000021069