Skip to Content
Technical Articles
Author's profile photo Former Member

Step-by-Step Guide: Creating a SAP Analytics Cloud (Formerly SAP BusinessObjects Cloud/SAP Cloud for Analytics/C4A) Analytic Model by importing data from Excel

Hi Everyone!

 

You might have already seen a lot of training videos about SAP Analytics Cloud (Formerly SAP BusinessObjects Cloud/SAP C4A) published by SAPAnalyticsTraining here. The purpose of this blog is to make you better understand this topic by a hands-on exercise that I have created. I hope it makes it simpler for you to learn and implement this easily. In this blog, you will learn about creating an analytic model in SAP Analytics Cloud by importing data from an excel file. You can use any data that you have. 

Let’s begin with an introduction:

SAP Analytics Cloud (Formerly SAP BusinessObjects Cloud/SAP C4A)  combines all analytics capabilities including planning, predictive analytics, and business intelligence (BI) – in a single SaaS solution.

Models: A model is a representation of the data and is required to perform the analysis and communication of the data. With SAP Analytics Cloud Modeler, the user can create different models for further analysis and to even create stories for a better representation.

For more information, please have a look at this User Guide provided by SAP.

Here, we will be creating an Analytics-Type Model by importing data from an excel file.This example talks about the sales data of a super market like Product Name, Profit, Discount, etc. After this exercise, you would have a complete data model in SAP Analytics Cloud and you can later use this to create stories.

Creating an Analytic Model:

As soon as you log in, you can see the homepage which looks like this:

 

sap c4a.PNG

 

Your Home screen is the place where you can pin reports, stories, and visualizations, as tiles. You can also add personal notes and upcoming events there. When you first start SSAP Analytics Cloud, the Home screen displays quick-launch shortcuts that can help you get started working on your analytics tasks right away. For example, you can:

  • Drag an Excel file onto the Home screen to import the data.
  • Launch the Financial Planning Wizard to create plans on the fly.
  • Start the Explorer, where you can begin analyzing data and creating visualizations.

 

Steps:

1. You can directly drag and drop a source file into the “Connect To Data” block of the homepage or you can click on “Home” and then select “Modeler”.

/wp-content/uploads/2016/05/p2_938855.png

 

2. Click on the “+” icon on the top right corner of the page.

/wp-content/uploads/2016/05/p3_938856.png

 

3. Select “Import File from your computer”.

/wp-content/uploads/2016/05/p4_938857.png

 

4. Select the source xslx file you downloaded from here. Select the Orders page. Then click on “Import”.

/wp-content/uploads/2016/05/p5_938858.png

 

5. Then, you will be redirected to this page:

/wp-content/uploads/2016/05/p6_938859.png

6. The import process analyzes the source data and creates an initial data view with proposed dimensions for the new model. You then refine the proposal by specifying the attribute type for each dimension in the new model. Select “Order_Quantity” field and change the Attribute Type from “Property” to “Measure”. Measures represent quantifiable data such as revenue and quantity sold.

/wp-content/uploads/2016/05/p7_938860.png

 

7. You need to mark a field’s Attribute Type as ID if you would want to visualize this against measures when creating stories.

 

8. Select “Order_Date” and change the Attribute type to “ID”.

/wp-content/uploads/2016/05/p8_938864.png

 

9. Now Select the Dimension Type to be “Time”.

/wp-content/uploads/2016/05/p9_938877.png

 

10. Select “Longitude” field and click on “Create Location”.

/wp-content/uploads/2016/05/p10_938878.png

 

11. Make sure that “Latitude” and “Longitude” are selected as shown.

/wp-content/uploads/2016/05/p11_938894.png

 

12. Select “Create Model”.

 

13. Click on the save icon.

/wp-content/uploads/2016/05/p12_938895.png

 

14. Select “ACCOUNT_AUTO”. Select the Aggregation type of each of these measures to “SUM”.

/wp-content/uploads/2016/05/p13_938896.png

15. Click on the Save icon. You have successfully created a model on SAP BusinessObjects Cloud by importing data from an excel file.

 

Summary: You have just created a model by following these steps:

 

  1. Selected a source file and entered a name for the model that will be created.
  2. Started the import process, which creates the initial data view.
  3. Specified attribute types for the dimensions.
  4. Started the automatic creation of the model.

 

This model can then be used to create stories in SAP Analytics Cloud (Formerly, SAP BusinessObjects Cloud/SAP C4A).

Assigned tags

      10 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Neven Terziev
      Neven Terziev

       

      hey Apoorva,

      thanks for your blog! The Excel file is not available at the doc Center you've kindly provided. The presentation sheet is available, but empty. Could you, please, chek that?

      thanks!

      Neven

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Neven,

      Thanks for your comment. I have updated the document. Please have a look.

      Author's profile photo Former Member
      Former Member

      Hey experts! I hope you are fine !!

      I have a doubt:
      For users to create models by hana calculations views (BOC only) is it necessary to register the user's P-USER (or S-USER) also in HCP or just in the BOC ???

      I believe it is only in the BOC, but I would like the opinion of our specialists. Can someone fix me?

      Thank you very much in advance.

       

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Thallita,

      Thanks for your comment. I’m not really sure about the S-User. Perhaps you can contact SAP Analytics Cloud support.

       

      Author's profile photo Frederic Lopes
      Frederic Lopes

      Hello,

      Your file is not avalaible, can you send me please?

      Regards,

       

       

      Author's profile photo Former Member
      Former Member

      Thanks for sharing.

      Author's profile photo IVAN GATEV
      IVAN GATEV

      Hi Apoorva,

      unfortunately, the excel sheet is not available, again.

      Please, could you provide it to me.

      Thank you in advance!

      Author's profile photo Arun Aravapalli
      Arun Aravapalli

      Hi,

      I am unable to download the file.

      Throwing an error.

      Could you please send/share me the same file with.

       

      Thanks in advance

      Author's profile photo Mauricio Rodriguez
      Mauricio Rodriguez

      Hey there,

      thanks for the article, but unfortunately Im not able to download the excel file, is there any other place I could get it?

       

      Regards!

       

      Thanks in advance!

      Author's profile photo Ravi Yadav
      Ravi Yadav

      Hi,

       

      I'm unable to download the file says file moved or deleted.

      could you please share the file.

       

      thanks in advance.

       

      Regards