direct discovery

[omid5ive]

hi

i want to use direct discovery in my qlikview document

i have two query:

normal:

sql select region_id,country_id from countries;

direct:

DIRECT Select region_id,region_name from regions;

when i reload this i get this error :

Error -- expected "query", found ":

DIRECT Select region_id,region_name from regions"

direct:

DIRECT Select region_id,region_name from regions

how can i solve it?

[maxgro]

DIRECT QUERY

dimension

region_id,

region_name

from regions;

;

[omid5ive]

sorry have you any sample?

[maxgro · Accepted solution]

yes some little queries, but they work on my oracle test db, you have to adapt to your db

OLEDB CONNECT32 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=test;Data Source=dev11;Extended Properties=] (XPassword is xxxxxxxxxxxxxxx);

DIRECT QUERY

dimension

  COD_SOCIETA,

    COD_CLIENTE_COMMITTENTE,

    COD_CLIENTE_DESTINATARIO,

    COD_FAMIGLIA,

    COD_PRODOTTO,

    NUM_NUMERO,

    COD_ORG_COMMERCIALE,

    COD_CANALE,

    COD_SETT_MERCEOLOGICO

measure

    QTA_PDV_SERVITI

FROM DWH_DL.MS01_DIFFUSO

WHERE NUM_NUMERO LIKE '40%'

;

this is another one

DIRECT QUERY

dimension

COD_SOCIETA,

    COD_CLIENTE_COMMITTENTE

FROM DWH_DL.MS01_DIFFUSO

;

[omid5ive]

Thank you