Skip to Content

SAP recently launched SAP Cloud for Analytics (C4A) a Software-as-a-Service (SaaS) offering natively built on the SAP HANA Cloud Platform. In this tutorial, you will learn how-to setup HANA Cloud Platform multitenant database as a remote source and use SAP Cloud for Analytics to visualize and share the insights with other users.

 

 

Overview.PNG

 

Prerequisites

 

  • Access to trial landscape, you need to have a developer account first. If you still need to create a developer account, you can start from here: Signing Up for a Developer Account.

 

  • Access to Cloud for Analytics account, to register you can start from here: Discover Cloud For Analytics. *Live Data Connection is only enabled in Production Account.

 

Instructions

 

To create and configure a trial tenant database, follow these steps:

 

  1. Log on to the SAP HANA Cloud Platform cockpit and select an account.
  2. Choose Databases & Schemas from the menu on the left. Choose New.
  3. In the Database ID enter a unique ID that contains lower-case letters and numbers.
  4. In the Database System field select the HANA MDC (<trial>) option. Fill in the SYSTEM User Password field. Choose Save.
    The Events page is displayed. It shows the progress of the database creation.

NOTE* If there are no free resources available you will not be able to create a tenant database. You should try again later. Free Trial also offers maximum of three Databases & Schemas which you can assign to your account.

 

S1.PNG

5. Wait until the tenant database is in Started state. This process might take a while

 

S2.PNG

 

Now you have your tenant database created and configured. Click on Administration Tools: SAP HANA Cockpit.

 

6. This will open-up log on screen to an Administrative console (Username: system) and your previously saved password for Database/Schema. Disregard Information screen by clicking on Ok button – new roles will automatically become assigned after your confirmation.

 

7. This leads us to a SAP HANA Database Administration screen. Click on Manage Roles and Users Tile to proceed.

S5.PNG

 

8. This will open up HANA Web-based Development Workbench: Security screen. Double-Click on the SYSTEM users and search through SYSTEM Users by clicking on the green + sign:

 

S6.PNG

 

9. Under Type name to find a role, select the following roles:

  •     sap.hana.ide.roles::CatalogDeveloper
  •     sap.hana.ide.roles::Developer
  •     sap.hana.ide.roles::EditorDeveloper
  •     sap.hana.xs.lm.roles::Administrator
  •     sap.bc.ina.service.v2.userRole::INA_USER

S7.PNG

 

10. Click on the Save icon.

Save.PNG

 

11. Click on the Link icon and open Catalog

/wp-content/uploads/2016/03/catalog_902670.png

12. Click on SQL icon, copy the content from file (attached below) CreateTable.SQL.txt into it and click on the execute arrow button. Successful execution will show COUNT(*) of 91.

SQLLOad.PNG

13. Click on the Link icon and select Editor

Edit.PNG

 

 

14. Right-click on the Content folder, select NewPackage

Cont-PAck.PNG

15. Enter c4aview as Package name and confirm it by clicking on the Create button

 

c4aw.PNG

16. Right-click on the package, select New – File an name it AN_CUSTOMER.analyticview

VS.PNG

17. Copy the content from file (attached) AN_CUSTOMER.analyticview.txt into it and confirm it by clicking on the Save icon

AWS.PNG

 

 

18. Login to your C4A account with your details and click on Connection

 

c4a19.PNG

 

 

19. Click on the + button Live Data Connection > SAP HANA

LiveHana.PNG

 

20. Enter the following parameters:

  • Name : your system’s desired name (max 10 character)
  • Connection type: Proxy
  • Host: testc4a<accountname>trial.hanatrial.ondemand.com
  • User : System
  • Password : xxxxxxx (your password)

 

C4aTest.PNG

 

21. Remote system was added:

RSa.PNG

22. Got to Main Menu and select Modeler

Modl2.PNG

 

23. Click on Import icon and select Create Model from Remote System

 

 

24. Select your remote connection under System, select the Data Source: AN_CUSTOMER and give name to the model. Confirm everything by clicking on the Ok button

 

27.PNG

25. Go to Main Menu and select Stories and click on the + icon on the right hand side of the screen to create the new story

28.PNG

 

26. Enter Title, choose as path Public and confirm everything by clicking on the Create button

30.PNG

27. Click on Add Canvas icon to start your story

 

28. Click on the Data View and select + to Add New Data

33.PNG

29. Select Existing Data and choose from the drop down list your previously created model. Finalize everything by clicking on the Ok button

 

30. Click Page 1 link

35.PNG

31. And an object to your canvas clicking on Chart

36.PNG

 

32. Select your existing model and Chart based on your preference by selecting Axis 1 (Measure) and Categories (Dimension)

37.PNG

 

33. Click on the + icon to add another chart, pick your existing model and select pie chart with the following parameters:

  • Chart Type: Pie Chart
  • Values: Net_Amount
  • Color: Country
  • Click on the Save button and click on Present

 

This will drive you to the point where you can share created visualization by clicking on Share button in the next screen…

39.PNG

40.PNG

This will conclude part 1. By now, you should have a good understanding about SAP HANA Cloud Platform and its native set of capabilities to integrate with Cloud For Analytics. In part 2, we’ll have a closer look on some of the additional things that we can do using SAP HANA Cloud Platform.

 

Special Thanks to:

An exceptional colleague of mine Thomas Andreas Muller.

To report this post you need to login first.

22 Comments

You must be Logged on to comment or reply to a post.

        1. Megha Jain

          Hello Pavel,

          We faced the similar situation.

          Possibly, C4A instance that you have is a productive instance and as you are trying to connect trial HCP account which should generally be not allowed in any real-time project scenario. Hence all “unsafe” or “not recommended for production use” items are not included.

          We raised OSS ticket with SAP requesting enablement of Proxy function in C4A instance.

          Hope this helps!

          Regards,

          Megha

          (0) 
        2. Ryan Lang

          The ‘proxy’ setting needs to be enabled on the back end by the BoC administrator. If you contact the back end SAP people responsible for your BoC system, they can enable it for you.

          (0) 

Leave a Reply