Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
srik00001
New Contributor II

Direct discovery syntax

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];

Tags (2)
1 Reply
Employee
Employee

Re: Direct discovery syntax

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

Community Browser