topic Re: Direct Discovery Script is not working in 11.2 SR5 in QlikView

Direct Discovery Script is not working in 11.2 SR5

Tue, 18 Aug 2015 12:48:23 GMT

Hi Forums,

I had sqlserver database and QV 11.2 SR5. Where I had table named as test_users Table with 2 column i.e. Firstname, Surname.

In Edit Script after doing the Database Connection. Following script is written which is working fine as follows:-

Tab1:

Sql Select FirstName, LastName from test_users;

Now I want to implement the Direct Discovery Functionalty. So, I had written the following script. as follows in script editor:-

Tab1:

DIRECT Select FirstName, LastName from test_users;

Which is not runing. Showing as Syntex errow Msg which is as follows:-

Syntax error.

tab1:

Direct Select FirstName, LastName from test_users

Can anybody please check and tell me where I am wrong. Please help me.

Advance Thanks

Re: Direct Discovery Script is not working in 11.2 SR5

jonathandienst — Wed, 19 Aug 2015 06:32:40 GMT

Do you have one of those fields (FirstName or LastName) in the normally loaded portion of the model? These values look like dimension values - do you really need DD for that?

Re: Direct Discovery Script is not working in 11.2 SR5

Wed, 19 Aug 2015 08:30:52 GMT

Hi Jonathan,

Yes, I want. Can you please show the way out.

Thanks

Re: Direct Discovery Script is not working in 11.2 SR5

jonathandienst — Wed, 19 Aug 2015 08:37:14 GMT

You have not really answered my questions, so I cant really help you.

Re: Direct Discovery Script is not working in 11.2 SR5

Wed, 19 Aug 2015 09:22:21 GMT

Hi Jonathan,

Apology, I may not given the answer to your question.

But my aim is to implement the functionalty of DD. Can you please provide/guide on DD with simple/example by QVW file.

Thanks

Re: Direct Discovery Script is not working in 11.2 SR5

robert_mika — Mon, 19 Oct 2015 09:19:19 GMT

Direct Discovery_Demo_Adworks_11.2_SR5.qvw