topic Re: Stored Procedure in qlikview in QlikView

Stored Procedure in qlikview

pooja_prabhu_n — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I am not able to fetch the data from the stored procedure only from the tables mentioned in screenshot below.

I am able to fetch all the other tables except 3 tables mentioned above .I am using below query to fetch the data and it is working fine for other tables.

SQL

SET NOCOUNT ON

EXECUTE [dbo].[tablename] '$(vID)' ;

Dashboard is throwing the below error:

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Could not find stored procedure 'dbo.Table name'.

what does lock symbol indicates in the above picture and how to fetch data from system stored procedures.

Any suggestions on this would be helpful.

Thanks,

Pooja

Re: Stored Procedure in qlikview

tresB — Wed, 08 Aug 2018 12:09:20 GMT

The padlock suggests it is encrypted. Check What is a stored procedure with a padlock icon in SQL Server 2005? - Stack Overflow You might not be able to get the data using this without the help of the DBA/developer or the owner of the same.

Re: Stored Procedure in qlikview

pooja_prabhu_n — Wed, 08 Aug 2018 13:19:12 GMT

Hi,

Thank you for your response.

Could you please help me in fetching the data from stored procedure into qlikview.

Thanks,

Pooja