Skip to Content
Technical Articles
Author's profile photo Sumin Lee

Beginner’s SAP Analytics Cloud Journey: Day1


Dear SAP Analytics Cloud beginners,

This is a blog post for beginners in SAP Analytics Cloud. I also started learning SAP Analytics Cloud from August 2021. I’d like to share my trial and error from a beginner’s point of view, and hope it helps you get started easily!

Day1: Time Series data

Time series data is a sequence taken at a successive equally spaced points in time and sequence of discrete-time data(reference: Wikipedia). Examples of time series data are weather forecasting, historical sales data and historical stock prices. Time series data analysis allows you to find factors that affect a particular variable over a given period of time.

Before create time series data chart in SAP Analytics Cloud, please refer to the pre-requisites as follows.


  • Sign-in SAP Analytics Cloud using your email address and you can get the trial for free.
  • The total usable time of the SAP Analytics Cloud free trial is 90 days
  • Link to SAP Analytics Cloud
  • Link to SAP Analytics Cloud Trial

Create chart using aggregated time series data

Step1: Create time series data in Excel.

Time%20series%20data%20in%20excelTime series data in excel

Step2: Create new story


Step3: Add data


Step4: Click data uploaded from a file

There are three options to add data. (Please click the “data uploaded from a file”)

  • Data uploaded from a file
  • Data from a datasource
  • Data from a existing dataset or model


Three options to add data

Step 5: Select source file and click Import.

Step 6: Create Dataset from File


Import data

Step7: Check Measures and dimensions

When uploading the data, default Measures are as below. But, to analyze the data, it requires to transpose the data from columns to rows in the next step.


Check Measures and Dimensions

Step8: Transpose columns to rows

To analyze the Time Series data, the structure of data has to be transposed.

Before Transpose


BeforeTransposed(Click Transpose button)


After Transpose

You can check the transposed dataset as below. Now, data is prepared and you can create chart!

Transposed%20dataTransposed data

Step9: Insert chart

Click insert chart and select the “Comparison: Combination stacked column & Line” and “Trend: Line” in this tutorial.


Insert chart


Insert chart: Comparison


Step10: Create calculation

We can use calculated values as Column Axis. Please click the red box, “Create Calculation”.        You can create the calculation using “Calculation Editor”.


Create calculation


In this tutorial, firstly, I create the “Type:Aggregation calculation” using SUM of value. The Aggregation dimension is by monthly.


Calculation: Sum of Value


In addition, I create the “Type:Aggregation calculation” using AVERAGE of value. The Aggregation dimension is by monthly.


Calculation: Average of Value


You can check two comparison chart and two Trend chart as below.

Step11: Edit custom order

In this tutorial, the member order is not a monthly order, for example, Apr-Aug-Dec-Feb….

But you can edit Member order by monthly, please click the yellow box to edit/create custom order.

Please create custom order with “Add Custom Order


create customer order

You can drag and drop by monthly order as below.


Custom Order

You can also apply created Custom Order to the other chart.


Add custom order

Step12: Completed!

You can check the finalized the two comparison chart and two Trend chart as below.


Create chart using non-aggregated time series data

Above example was creating chart using aggregated time series data by monthly. But, normally, we have time series dataset such as 01/Jul/2021, 02/Jul/2021, 30/Jul/2021 and others. In this section, we will create the chart using unaggregated time series data.

This is an example of a time series data set containing document numbers, dates, and quantities. The example data was generated using the Excel random between function. (If you’re working on a logistics area, the dataset will be familiar.)


Example of unaggregated dataset- Delivery document information


Step1: Upload dataset

You can directly upload dataset in the story.


Upload data in the story

Step2: Check Measures and Dimensions



Step3: Create chart-Trend:Time series

You can create chart Trend:Time Series as follows.


Create Trend chart:Time Series.


Step3: Create chart-Trend:Line

You can also create trend chart with Line. But in the beginning, you will see a strange chart like below.

Don’t surprise! 


Step4: Set Hierarchy

You can set the date hierarchy by yearly, quarterly and monthly, and It’s useful.

If you can’t find the “Set Hierarchy”, please refer to Beginner’s SAP Analytics Cloud Journey: Day2- Datatype and data transform.



Set date hierarchy



Set Hierarchy: Level 2- yearly



Set Hierarchy: Level 2- Quarterly



Now you can now create charts and analyze time series data in SAP Analytics Cloud👏👏👏!

As mentioned above, Time series data analysis allows you to find factors that affect a particular variable over a given period of time.

In my opinion, checking datatype and transform data are pre-required steps before creating charts and analyze data in SAP Analytics Cloud. If you’d like to learn more about charting and analyzing time series data? Please refer to my blog posting: Beginner’s SAP Analytics Cloud Journey: Day2


Following on Beginner’s SAP Analytics Cloud Journey: Day3 – How to insert Geo Map.  


Learn more about SAP Analytics Cloud

  • Want to play around with SAP Analytics Cloud yourself? Download a trial version here
  • Locate the “?” symbol on the top of your SAP Analytics Cloud window to access the help documents, including guided playlistsknowledge basebrowse community, etc.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Swapnil Galgali
      Swapnil Galgali

      Nice Blog. Thanks Sumin Lee.

      Author's profile photo Sumin Lee
      Sumin Lee
      Blog Post Author

      Thanks Swapnil Galgali , I hope you see you again at the next posting!

      Author's profile photo Abinaya Rajeshkannan
      Abinaya Rajeshkannan

      Great Blog Sumin 🙂

      Author's profile photo Sumin Lee
      Sumin Lee
      Blog Post Author

      Thanks Abinaya Rajeshkannan! See you soon:)

      Author's profile photo Schalk Klee
      Schalk Klee

      Hi Sumin,

      Great start! Looking forward to the rest.

      Author's profile photo Sumin Lee
      Sumin Lee
      Blog Post Author

      Thank you Schalk Klee, I will try my best to share my experience 🙂

      Author's profile photo Nimish Garg
      Nimish Garg

      Nice blog...Add some custom heirarchy also.

      Author's profile photo Sumin Lee
      Sumin Lee
      Blog Post Author

      Hi Nimish Garg,

      Thanks for your comments! We hope that the following blog post will be helpful to you (Link to Beginner’s SAP Analytics Cloud Journey: Day2).

      Author's profile photo VIPIN SARAIKA

      Hi Sumin,


      Great Blog!


      I tried following the steps but somehow I got stuck in Add Measure step (Create Calculation) in the calculation editor. There are no values in the dropdown of Measure and also I can't find Month as a dropdown in Aggregation dimensions. Kindly suggest.



      Measure Dropdown



      Aggregation Dimensions dropdown




      Author's profile photo Sumin Lee
      Sumin Lee
      Blog Post Author

      Hello Vipin Saraika ,

      Thank you to read my blog!


      Could you please check the Measure and Dimension in the dataset?

      You can drag and drop from Dimension(e.g. KEY, Product, VALUE) to Measure.

      For example, I set Qty to Measure.

      Step1) Check and change the Measure and Dimension


      Change dataset from dimension to measure

      Step2) Save it

      Step3) Go to Stories

      Step4) Calculation Editor


      I hope you find this recommendation helpful.



      Sumin, Lee

      Author's profile photo VIPIN SARAIKA

      Thanks, Sumin!

      I am able to do it now after following the steps mentioned by you.


      Author's profile photo Sumin Lee
      Sumin Lee
      Blog Post Author

      You welcome Vipin Saraika! I'm glad it was helpful.

      Author's profile photo Naresh T
      Naresh T

      Hi Sumin,


      Well explained in step by step.

      NIce blog

      Author's profile photo Yasin N
      Yasin N

      Hi, Sumin


      your blog it is very helpful.

      SAP Analytics Cloud is promising platform for data scientists, data mining, data science...etc.