In certain business environments all the complex business logic is implemented in a stored procedure.
This usually happens when the source system is a huge transactional database system and data warehouse is not available.
In such scenarios you have two choices
– load all the tables in QlikView and recreate stored procedure logic
– execute the stored proc and get the required data
Here we will discuss if you have to opt for the second choice.
Executing Stored procedure in QlikView
In QlikView executing stored proc is very simple, see below i am running a stored proc named SalesByCategory
which accepts two parameters CategoryName and OrderYear
the output of this stored proc will be created as a table in QlikView which can be used as any other table in Qlikview
You can execute multiple stored procedures and join the resulting tables as needed.