Warehouse Release 3.04.0050

5/16/2014

The feature in the 3.04.0050 release is:

• Google Analytics access is now available. Some setup is required. Java and Google libraries need to be installed and the wh.ini file needs to be updated. For full installation instructions, see our support page at:
  
  http://www.taurus.com/support/googleAnalytics/n_googleAnalytics.html
  
  To access Google Analytics data, your web pages must be setup to collect Google Analytics data and you must have a login from Google.
  
  The OPEN syntax is:

      OPEN db-tag GA USER=google-user PASS=google-pass ID=viewID
  
      google-user     is your Google user or email address.
  
      google-pass     is your Google password.
  
      viewID          is the Google ViewID of your data view.
  

  To read Google Analytics data, you must have an internet connection. Your Warehouse script must use a FORMAT statement that specifes the dimensions and metrics to return. Google Analytics access must always have a start date and end date in YYYY-MM-DD format. The dimensions and metrics available are contained in the file CSV test file WHGAITMS installed with Warehouse. The description of the items is available from Googgle at:
  
  https://developers.google.com/analytics/devguides/reporting/core/dimsmets
  
  Example script:

      OPEN G GA USER=yourGoogleUser PASS=yourGooglepPass ID=yourGoogleViewiID
  
      FORMAT GAFMT : RECORD
          NV : GA METRIC VISITS
      END
  
      READ GR = G FORMAT GAFMT FOR STARTDATE = &
            ($NOW - CONVERT(STR2DATE("30","NN"),"INTERVAL") PIC "YYYY-MM-DD") &
            AND ENDDATE = ($NOW PIC "YYYY-MM-DD")
          PRINT NV
      ENDREAD
  

Release 3.04.0050 is available now on all supported platforms.