Try DataDirect Cloud Now
skip to main content
Mapping tab options : Default View
 

Default View

The defaultView map option applies to GoogleAnalytics data stores.
The defaultView map option sets the default name for a viewId. Many of the queries for Google Analytics require a viewId, and the value of the id isn't obvious. However, the name of the view is generally displayed in the upper-right corner of the pages in Google Analytics. At connection time, the DataDirect connectivity service looks up the name and adds a WHERE viewId = to each WHERE clause that supports viewId and doesn't have an explicit viewId in the user's query.
The valid value for defaultView is a valid view name.
When not specified, the viewId must be specified on every query that returns metrics or that uses dimensions (that is, all of the pseudo-tables and the "Data" table). You can also retrieve the view names by executing the query SELECT name FROM view.