database process query help

[#1]

hieeee

I am facing a problem in fetching data from database. I know qlikview can easily fetch data in the form of tables from database...

But what problem i am facing is that data is stored in database with some query.Can i able to fetch this data through qlikview.

Should qlikview able to read this type of data....

please explain 

[swuehl]

You can use the SQL statement in your script to pass SQL code to your DB, for example

SQL Execute <storedProc>;

You might need to enable read and write access to your DB, depending on what your stored procedure does.

You can also consider creating a view in your DB and just access the view like a common table.

[#3]

plzzzzzzzzzzzzzz help

[Joseph_Musekura]

Hi,

With SQL , you can also create SQl View and  load SQL
view into QlikView . Ex:

Table1:

Load  f1,  f2,  f3

;

SQL SELECT f1, f2, f3

FROM my.dbo."Report_View";

Regards,

[#5]

means qlikview will be able to access that data but by creating view...

[Joseph_Musekura]

Yes., you can use VIEW  but also, if you have defined “ Stored Procedure” in SQL , you can use EXECUTE command  to load data in QlikView . As indicated in the first response you received, To be able to execute stored
procedures in QlikView, connection to the database must be opened in read/write mode:

ODBC Connect to mySQLDatabase;

Table1:

Load *;

SQL EXEC myStoredProcedure;

Regards