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