I’ll explain how to use the data from Google Spreadsheet on SAP Analytics Cloud.
After reading this blog post, you can import data from Google Drive and create batch scheduling to refresh data.
1. Prepare the dataset on Google Drive
First of all, you have to create a dataset and upload the file on Google Drive.
You can edit data on Google Spreadsheet. The points to change will be reflected after refreshing on SAP Analytics Cloud.
2. Create connection with Google Drive in SAP Analytics Cloud
Then, we will create connection between Google Drive and SAP Analytics Cloud.
Open SAP Analytics Cloud and move to “Modeler”.
Select “From a Data Source”.
Select “Google Drive”.
Select “Google Account” and click “Create New Connection”.
Select Google Account that you upload the dataset.
Fill out “Google Account Name” and “Description”.
Select “Google Account” that you registered.
You can see the file(dataset) you upload.
Select the file and you can access the dataset on Google Drive.
Setup the model and click “Create Model”.
3. Visualize the dataset
Move to “Stories” and select the model.
You can visualize the datasets from Google Drive.
4. Refresh data on SAP Analytics Cloud
You can add modifications to Google Spreadsheet.
After edited the datasets, you need to open the model and click the refresh icon.
The model was refreshed manually.
If you create batch scheduling, click the calendar icon to setup.
You can create connection with Google Drive and refresh data easily in SAP Analytics Cloud.
Check steps below to do smoothly.
- Prepare the dataset on Google Drive
- Create connection with Google Drive in SAP Analytics Cloud
- Visualize the dataset
- Refresh data on SAP Analytics Cloud
If you need more help, please leave me a comment.