In the previous blog, we looked at the different connectivity options that exist so far for SAP Cloud for Analytics. Now we will put this to work by using a Google Sheet and create a model based on the Google Sheet.

For my example, I am going to use a very simple Google Sheet that outlines the Revenue, Cost, and Profit for a set of products broken down by year and month.

SAP Cloud for Analytics: Getting Started – Using Google Sheets

In this example, we will create a model and load the data into the model. Please note that you could also just connect to the Google Sheet and explore the data.

So let’s create the model, upload the data, and then create a visualization.

  • Log on to SAP Cloud for Analytics.
SAP Cloud for Analytics: Getting Started – Using Google Sheets
  • In the menu (top left corner), select the menu item Modeler.
  • Now in the top right corner, click on the icon “Import Data”.
SAP Cloud for Analytics: Getting Started – Using Google Sheets
  • Select the option “Import Model from Google Drive”.
SAP Cloud for Analytics: Getting Started – Using Google Sheets
  • In the next screen, you can enter a name and description for your Target Model.
SAP Cloud for Analytics: Getting Started – Using Google Sheets
  • After entering those details, click on Select Data. If you are already logged in with your Google Account in the browser, you will see a list of data sources, otherwise you will be asked to log in with the Google Account.
SAP Cloud for Analytics: Getting Started – Using Google Sheets
  • I will then select the Google Sheet ‘C4A_Sample’ and click on Import.

After we import the sheet, we are presented with the Data View and we can now configure the details in our model

SAP Cloud for Analytics: Getting Started – Using Google Sheets

You can click on the column header for dimension Product and you can then see the details on the right hand side.

SAP Cloud for Analytics: Getting Started – Using Google Sheets

In my example, I selected the option “ID”. The other available options are “Description” in case you have a Key and Text in the source data, “Hierarchy” to configure a hierarchy, “Property” to configure a Attribute in BW terms.

Then I select the column Year and also set it to the type “ID” but this time I set the Dimension Type to “Time” and the Time Format to “YYYY”.

SAP Cloud for Analytics: Getting Started – Using Google Sheets

Then I move on to column Month and also set the Dimension Type to Time but set the Time Format to Unique Values.

Here I was hoping for an option to be able to enter a custom format – for example MM or MMM (like in Excel) – but there was only a list of predefined formats available and none of them was only the Month.

SAP Cloud for Analytics: Getting Started – Using Google Sheets


For the columns Revenue, Cost, and Profit, I will set the Attribute Type to Key Figure.

SAP Cloud for Analytics: Getting Started – Using Google Sheets

On the Key Figure part, I noticed that there wasn’t an option to configure the number of decimals and a scaling factor – perhaps something in the next release.

After that I click on Create Model and…..

I received the message that I can only have one time dimension per model, so I moved the Month back to a normal dimension.

I guess I will have to solve that issue by setting up a time hierarchy.

The model got created and I was able to go back to the Home page and use the option “Explore Data” and see the data from my model.

SAP Cloud for Analytics: Getting Started – Using Google Sheets

In the next step, we will setup a proper time hierarchy, fill the descriptions, and setup a product hierarchy.

Got questions? Click here to reach out to us.


Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com


Copyright © Visual BI Solutions Inc.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Share This!

Share this with your friends and colleagues!