Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have never pulled data using stored procedure. I was able to make a connection to the database but don't know where to go from here.
The stored procedure that was loaded is : BookOfBusiness
I have attached what I see when I make a connection to the database
Thanks,
Zag
Hi,
As far as I know you can't load SP into Qlikview. You can load views instead of a SP, I think the reason is that the SP has some programming behind and Qlikview can't translate it into something that it can be read into the script.
Best regards,
Andrés
I have reaed where others have done it - just am clueless since I have never tried.
This should execute an return your procedure
SQL EXEC BookOfBusiness;
Thanks for the response. I got an error message (below). I was able to connect to this server so not sure why I would get this..
ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: The EXECUTE permission was denied on the object 'BookOfBusiness', database 'EpicSub', schema 'dbo'.
SQL EXEC BookOfBusiness
it seems you miss the right to execute the procedure
ask your dba for a (probably) grant exec on .... to .....
The error message is self-explanatory, you don´t have access to execute that procedure
Thanks I will check. Sorry never use a stored procedure before so pretty lost right now.
Thanks - that was it.