The New Age of Analytics – SCP && SAC

[nash_gajic]

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

 



 



 

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.

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

 



 

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.



 

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:

 



 

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

 

10. Click on the Save icon.



 

11. Click on the Link icon and open Catalog



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.




13. Click on the Link icon and select Editor




 

 

14. Right-click on the Content folder, select New – Package



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

 



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



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




 

 

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

 



 

 

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



 

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)

 



 

21. Remote system was added:



22. Got to Main Menu and select Modeler



 

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

 



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



 

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




27. Click on Add Canvas icon to start your story

 

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




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



31. And an object to your canvas clicking on Chart



 

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



 

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...





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 C...

Code samples:

https://www.dropbox.com/s/vkpl3f8bjs26s2x/CreateTable.sql..txt?dl=0


https://www.dropbox.com/s/8xbgwxi8ib4vbmz/AN_CUSTOMER.analyticview.txt?dl=0

 

Special Thanks to:

An exceptional colleague of mine Thomas Andreas Muller.

[JohnL]

Great blog Nash

c4a_related

[AntonyJerald]

Hi,

Nice document.  Thanks for sharing.

Can you please provide the url for C4A trial account where I can register?

Regards,

Antony Jerald.

[JohnL]

Cloud Based Analytics Trial

[sdebeaulieu]

Hi,

In C4A menu, I have only few possibilities. May you tell me if I have to ask for new roles. If so, what are necessary roles?

Cheers,

Severin

[sdebeaulieu]

Available menus: Home - Stories - Files - Events - About

[JohnL]

Ask here: SAP BusinessObjects Cloud

[Former Member]

Hi John,

can a normal user have access to Trial Account? I dint find it on the url you provided above.

[JohnL]

Hi Yogendra

Please speak with your SAP account executive or your partner service manager.

Thanks

[Former Member]

Does C4A comes with HCI account as well or we need to sign up separately? Any pointers appreciated.

[Murali_Shanmu]

Hi Ganesh,

I dont think C4A comes with HCI account. You will  need to sign up for that separately.

[Former Member]

Hi all,

we are trying to connect trial HCP to C4A but the remote systems menu is not visible, is there any trick how to add this item?

Thanks

[MatthieuPelatan]

Hi Pavel,

the UI has been changed for a couple of weeks. You will find it now under "connections".

I did it last week and it worked fine.

[Former Member]

Hi Matthieu,

we have no possibility how to connect HCP via proxy, only path is available

[Former Member]

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

[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.

[nash_gajic]

To avoid confusion for a setup of Reverse proxy please refer to help guide listed below:

https://cp.hana.ondemand.com/dps/d/preview/1949b084ea3343df9e83923e906b7a03/release/en-US/frameset.h...

[christoph_pahlke-lerch]

Hi Nash,
I would like to do your tutorial but I miss the mentioned files. Do you know where to find them?
Thanks and Regards, Christoph

[JohnL]

Please see the following blogs for updated SSO workflows:

• Creating an End-to-end SSO Experience to SAP BusinessObjects Cloud and HANA with Kerberos and SAML


• Creating an End-to-end SSO Experience to SAP BusinessObjects Cloud and HANA with Client Certificate ...

[JohnL]

Hi Ryan, the proxy option is not supported. You need to use the new SAP HANA Cloud Platform connection type.

[Former Member]

Please attach the text files mentioned in the above document, so that we can check the code 🙂

[Former Member]

Hi!

Can not find the attached sql script file??

[former_member366610]

Attachment is missing.