Using variables in a QVSource GA Feed URL

[#1]

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%...XXXXXXXX%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?

[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.