topic Re: QlikView Direct Discovery Syntax Issue in QlikView

QlikView Direct Discovery Syntax Issue

Wed, 02 Apr 2014 13:27:26 GMT

I was trying my hand at Direct Discovery and i ran into some trouble with creating a direct discovery table. When inserting the direct Key-word I get the following error message:

Error -- expected "query", found "SELECT CUSTOMER_ID,
    ID,
    PRODUCT_CODE,
    QUANTITY
FROM PIVOT_TEST"

DIRECT SELECT CUSTOMER_ID,
    ID,
    PRODUCT_CODE,
    QUANTITY
FROM PIVOT_TEST

The Code snippet (for which the error is occuring) is as follows:

CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=XXXXXXX;Data Source=XXXXXXXX;Extended Properties=""] (XPassword is SVBFVBFISKReVJFIGKRIVMBa);

DIRECT SELECT CUSTOMER_ID,
    ID,
    PRODUCT_CODE,
    QUANTITY

FROM PIVOT_TEST;

Setting the value for STALE too has no effect, the same error occurs. Any idea why this occurs? On another note, where do I look for information around direct access?

Thanking you in anticipation,

Regards,

Mohit.

Re: QlikView Direct Discovery Syntax Issue

maxgro — Wed, 02 Apr 2014 13:44:32 GMT

DIRECT QUERY

dimension

CUSTOMER_ID,
ID,
PRODUCT_CODE

measure
QUANTITY
FROM PIVOT_TEST;

Re: QlikView Direct Discovery Syntax Issue

maxgro — Wed, 02 Apr 2014 13:46:33 GMT

http://community.qlik.com/blogs/qlikviewdesignblog/2012/11/08/qlikview-112-and-direct-discovery

QlikView Direct Discovery FAQ 11.2_SR5.pdf

http://community.qlik.com/docs/DOC-3710

Re: QlikView Direct Discovery Syntax Issue

Thu, 03 Apr 2014 04:59:12 GMT

Awesome. Thank you very much.