topic Re: direct discovery in QlikView

direct discovery

omid5ive — Sat, 05 Jul 2014 07:21:58 GMT

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?

Re: direct discovery

maxgro — Sat, 05 Jul 2014 15:56:08 GMT

DIRECT QUERY

dimension

region_id,

region_name

from regions;

;

Re: direct discovery

omid5ive — Sun, 06 Jul 2014 07:24:00 GMT

sorry have you any sample?

Re: Re: direct discovery

maxgro — Sun, 06 Jul 2014 10:07:37 GMT

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

;

Re: Re: direct discovery

omid5ive — Mon, 07 Jul 2014 05:50:59 GMT

Thank you