Create HANA 2.0 Custom View in SAP Web IDE using Cloud Foundry HANA Trial account: Part 1

[latha_b]

 

Part 1: Set up the Cloud Foundry Trail Account for using SAP Web IDE

 

With SAP Marketing Cloud you are able to import own SAP HANA Views by using the SAP Fiori App “Add Custom View”. This blog post will tell you steps you need to carry out to set up the SAP Web IDE to build the HANA Calculation Views.

There is an information that is now showing up in "Add Custom View" application in SAP Marketing Cloud that in the upcoming release HANA views would be migrated to HANA 2.0. Post that migration you can only import views that are modelling using HANA 2.0 Modeller ( ex: SAP Web IDE)

In this blog post it is explained how to set up SAP Web IDE in Cloud Foundry HANA Trail Account of SAP Cloud Platform.

 

Create TRIAL ACCOUNT in Cloud Foundry

 

 

Enter the HANA Trail account using URL URL: http://hanatrial.ondemand.com/.



 

If you have not created the trial account for Cloud Foundry you would be asked to create the trail account

Create the account and then global account, sub account, organisation and space would be created.

 

Click on continue post creation.

Click on service entitlement section and cross check if SAP HANA schema and HDI Containers(Trial) has been enabled for your account.

 

 

Enable Web IDE for HANA Views

 

Login to SAP Cloud Platform HANA trial account with the URL: http://hanatrial.ondemand.com/

 

Now click on SAP Web IDE.

 

If you are entering for the first time then you will be asked to enable the SAP Web IDE Full Stack. where you can enable the same as in below image.

 



 

After the service is enabled when you enter SAP Web IDE you would see below screen.

 

 

In SAP Web IDE select Preferences -> Cloud Foundry and  then select the  Frankfurt API end point which starts with api.cf.eu10.. as the API End point and then choose Organisation and space of the trial account.

 

P.S: If you are located in the region which is more closer to other data centre, you would have the Cloud foundry trial account and end point accordingly. For example if its US then you need to choose US API end point accordingly.

 

 

In Extensions Switch "ON" SAP HANA Database Development Tools and SAP HANA Database explorer

 

Log out post Enablement and then Log in again to the SAP Web IDE.

 

 

Now the set up is ready to build the new HANA calculation views in SAP HANA 2.0.

 

In part 2 we will cover how to export the HANA content from SAP Marketing Cloud, build the calculation view and import back into the application using Add Custom View Application.