1 Reply Latest reply: May 10, 2015 11:44 PM by Toni Kautto RSS

    Direct discovery syntax

    Sri Kitambi

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