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.

Pre-requisites

  • 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

Create%20new%20story

Step3: Add data

Add%20data

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%20options%20to%20add%20data

Three options to add data

Step 5: Select source file and click Import.

Step 6: Create Dataset from File

Import%20data

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%20Measures%20and%20Dimensions

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

Click%20Transpose

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%20chart

Insert chart

Insert%20chart%3A%20Comparison

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%20calculation

Create calculation

 

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

Calculation%3A%20Sum%20of%20Value

Calculation: Sum of Value

 

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

Calculation%3A%20Average%20of%20Value

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%20customer%20order

create customer order

You can drag and drop by monthly order as below.

Customer%20Order

Custom Order

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

Add%20custom%20order

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%20of%20unaggregated%20dataset-%20delivery%20information

Example of unaggregated dataset- Delivery document information

 

Step1: Upload dataset

You can directly upload dataset in the story.

Upload%20data%20in%20the%20story

Upload data in the story

Step2: Check Measures and Dimensions

Check%20Measures%20and%20Dimensions

 

Step3: Create chart-Trend:Time series

You can create chart Trend:Time Series as follows.

Create%20time%20series%20data

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! 

Create%20Trend%20chart%3ALine

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%20date%20hierarchy

Set date hierarchy

 

Yearly

Set Hierarchy: Level 2- yearly

 

quartely

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

      12 Comments
      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
      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%20Dropdown

      Measure Dropdown

       

      Aggregation%20Dimensions%20dropdown

      Aggregation Dimensions dropdown

      Regards,

      Vipin

       

      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%20dataset%20from%20dimension%20to%20measure

      Change dataset from dimension to measure

      Step2) Save it

      Step3) Go to Stories

      Step4) Calculation Editor

       

      I hope you find this recommendation helpful.

       

      Regards,

      Sumin, Lee

      Author's profile photo Vipin Saraika
      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.