Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello !
I have to import some Data from a Database. The Databas contains a big number of tables.
And I have to import some Data for making a nice BI for a client.
So far so good. But Im not realy keen in SQL, more in Controlling. But I realised there is
a stored procedure in my Database, which contains all my beloved data.
So I want to try to get the Data through the stored procedure.
But how to do, if you have no Idea ?
I read the related threads, but I couldn't solve the problem, with the containing information.
Is there out somebody which have easy examples, to become familiare with Import of stored procedures
in Qlikview.
My stored procedure:
SQL DataBaseName.dbo.GetMarginOverview '01.04.2011', '02.04.2011'
// The GetMarginOverview needs 2 Argumentes from and to (as Date).
// The Procedure is very complex, it contains 10 pages of SQL Statements
And the Procedure should return a big Table, with all related datas to show the margin of all products of the ERP System.
If there is some one with an Idea, how to come familiare, or with examples, or how to fix the problem, feel free
to post it.
Thanks in advance.
Werner Stiegler
Mr. Peter !
Sorry this Fred (thread ... ) don't help me by my problem.
I had read also some other postings to this topic.
Thanks for the try ... :-).
By,
Werner