Can we use Store procedure in Qlikview?

[srinivas1921]

Hi All,

I need to developed a application using Qlikview which is already developed in MSBI and all are store procedures only used to develop this application from MSBI side.Now my question was, how should we call these store procedures from qlikview side? Can we do this in qlikview? or in other ways how should we use same logic in QlikView side in easy way?

Please suggest me on this to develop this report in right approach.

Many Thanks in Advance................................

[luciancotea]

Yes

Your SP needs to return a dataset.

In QlikView script, you call the procedure with 'SQL' keyword in front.

[satishkurra]

Hi

Yes you can

Please refer the below link for more details.

http://www.learnallbi.com/executing-stored-procedure-in-qlikview/

[Colin-Albert]

You can use Stored Procedures to get data into QlikView.

Re: Executing a stored procedure

Search this site for "Stored Procedure" rather than store, as store is a command in QlikView and will give lots of incorrect  hits,

[Chanty4u]

stored procedure in qlikview script

[srinivas1921]

Hi

As you mentioned,It is working fine.But in my SP there are 8 parameters then, is it works fine in this case? or is any limit for parameter values to call the SP in qlikview?

[srinivas1921]

can we call this store procedure without giving parameter values?