Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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];
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