Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a stored procedure which contains 3 input parameters with multiple select and Inner joins.
I want to Call the SP in Qlikview. I followed lots of Blogs but I did't got sucess to Execute the SP in Qlikview. Help me.
I am Using OLEDB and my calling method is:
SQL CALL [DBNAME].[dbo].[ABC] @_EndTime ='2012-12-31 00:21:06.550', @_StartTime = '2012-12-31 00:21:06.550',
@_UserName = 'XYZ';
BTW, are you getting any errors? If not please check the SQL trace.
mean while you try to create test SP and call from your QV. See if it works or not.
See the error below:
if I'm doing like this the following error is coming :
ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: The EXECUTE permission was denied on the object 'SP name', database 'DBNAME', schema 'dbo'.
SQL exec [DBNAME].[dbo].[TABLENAME]
@_EndTime ='2012-12-31 00:21:06.550', @_StartTime = '2012-03-10 00:21:06.550', @_UserName = 'Sam.moni@xyz.com'
@KStreak S: In case of your syntex it is giving the same error.
what kind of pemission it requires for execution.
please give me some idea.
As error says, You need to get Permission to execute. Please check for the perticula user/role you have permission or not. If not ask your DBA to change the permission setting for
Try this GRANT EXEC ON dbo.xxxxxxx TO <UserName>
My DBA gave me some permission in SQL Server but still the problem is same.
Can you tell me to get permission what i need to do................... and where ??
Did you tried
GRANT EXEC ON dbo.xxxxxxx TO<UserName> ?
Greate thanks to you KSteeak it is connecting and working.
Request you to mark as an answer
Soory for the delay -
After getting Execution access the following syntex works for me:
SQL Exec [DBNAME].[dbo].[TABLENAME]
@_StartTime = NULL,
@_EndTime = NULL,
@_UserName = NULL;
Thank you
In Addition to this one more Query i have :
This is something I am getting based on particular user details but i need the same for all users, for that I wants to Store the SP data into QVD on regular basis. that helps to relate other tables with QVD to produce meaningfull Dashboard. any idea how to do this ??