1 Reply Latest reply: Nov 27, 2013 9:25 AM by Nicole Smith RSS

    Using variables in a QVSource GA Feed URL

    Viktoriya Shulian

      I'm trying to loop through a load script from QVSource Google Analytics connector.

      The script looks like the following:

       

      GoogleAnalyticsConnectorV3_DataFromQueryURI:

      LOAD

          dim_dateHour as DataFromQueryURI_dim_dateHour,

          dim_eventLabel as DataFromQueryURI_dim_eventLabel,

          dim_eventAction as DataFromQueryURI_dim_eventAction,

          metric_totalEvents as DataFromQueryURI_metric_totalEvents

      FROM

      [http://localhost:5555/QVSource/GoogleAnalyticsConnectorV3/?table=DataFromQueryURI&appID=&feed=https%3a%2f%2fwww.googleapis.com%2fanalytics%2fv3%2fdata%2fga%3fids%3dga%253AXXXXXXXX%26dimensions%3dga%253AdateHour%252Cga%253AeventLabel%252Cga%253AeventAction%26metrics%3dga%253AtotalEvents%26filters%3dga%253AeventCategory%253D%7estart%2524%26start-date%3d2011-01-01%26end-date%3d2013-11-26%26max-results%3d5000]

      (qvx);

       

       

      I'd like to loop through the bolded part of the connection string; it's an 8 digit number.

      How can I put a variable into the connection string?

        • Re: Using variables in a QVSource GA Feed URL
          Nicole Smith

          Here is an example of how I connect to my database using variables:

           

          OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=$(vDBName);Data Source=$(vDBServer);Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=$(vWorkstation);Use Encryption for Data=False;Tag with column collation when possible=False];

           

          Note that vDBName, vDBServer, and vWorkstation are all variables that I had populated earlier in my load script.