Direct discovery syntax

srik00001 — Thu, 26 Mar 2015 14:48:47 GMT

I am testing out Direct discovery for one of the scenarios we have and running into the below error. Can you help with the syntax?

Error -- expected <ColumnClauses>, found "

DIMENSION

[Company ID]

,[CompanyName]

MEASURE

[Sales]

FROM [dbo].[Company]"

DIRECT QUERY

DIMENSION

[Company ID]

,[CompanyName]

MEASURE

[Sales]

FROM [dbo].[Company]

Below is my load script

//ODBC CONNECT TO DSN_MM;

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Metric_Master;Data Source=gasqlst07d;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=GA-KITAMBIS2;Use Encryption for Data=False;Tag with column collation when possible=False];

DIRECT QUERY

DIMENSION

[Company ID]

,[CompanyName]

MEASURE

[Sales]

FROM [dbo].[Company];

Re: Direct discovery syntax

ToniKautto — Mon, 11 May 2015 03:44:59 GMT

Keep in mind that the script is transformed into a SQL query by QlikView. This means that you need to make sure the Direct Discovery variables are setup properly so that the SQL query is accurately composed and matches your data base expectations.

Please Direct Discovery Technical Addendum for more details; QlikView 11 2 Direct Discovery Technical Addendum 11.2 SR7.pdf

topic Direct discovery syntax in QlikView

Direct discovery syntax

Re: Direct discovery syntax