Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
To use Data Visualisation Desktop with data from Google Analytics
Summary
To use Data Visualisation Desktop with data from Google Analytics
Content
I created VA project that referring to the follwoing blog.
Connecting Oracle Data Visualization Desktop to Google Analytics and Google Drive
Get data from Google Analytics in Oracle Data Visualization Desktop,
I want to create the graph in time series.
The connection was successful, I can get GA data.
but I cannot add the Time dimension.
Does anyone know how to do it?
Answers
-
Do you already have Time Dimension created in some other datasource? where are you tying to add time dimension and from where?
Because its obvious you won't have same in non-modelled data source.
But if you have Time Dimension present in some other datasource then you can join your Google Analytics data source data with same,given that you have date columns to join with time dimension table, see below documents which explains how to connect two different data sources.
0 -
Thank you for your reply.
I want to add following Time dimension.
https://developers.google.com/analytics/devguides/reporting/core/dimsmets#view=detail&group=time
Time - Dimensions
ga:date
For example, Let's assume I create new datasource and add following Session metrics to Project.
https://developers.google.com/analytics/devguides/reporting/core/dimsmets#view=detail&group=session
Session - Dimensions & Metrics Explorer

If I want to add a second datasource (Time Dimension) to this project, What should I do?
GA Session metrics doesn't have Time Dimension...
0 -
Even if I could get report data from Google Analytics,
It should be meaningless unless we can add the Time dimension and perform time series analysis.
0