Direct Discovery Script is not working in 11.2 SR5

[#1]

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

SD

[jonathandienst]

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?

[#3]

Hi Jonathan,

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

Thanks

SD

[jonathandienst]

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

[#5]

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

SD

[robert_mika]

Direct Discovery_Demo_Adworks_11.2_SR5.qvw