Create HANA 2.0 Custom View in SAP Web IDE using Cloud Foundry HANA Trial account: Part 2
Part 2: Build the HANA Calculation view in 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 build the HANA Calculation Views.
There is an information that is now showing up in “Add Custom View” app 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 ( SAP Web IDE)
In this blog post it is explained how to build the HANA Calculation view using SAP Web IDE.
Part 1 has details about setting up the Cloud Foundry Trial Account for using SAP Web IDE.
For building calculation views first you need to export the HANA content from Add Custom view Application. The exported metadata which can contain the Table definition and view definition will be in the form of a zip file.
For building calculation views for SAP Marketing Cloud you can import the full Metadata which is exported from Add custom view App.
For simplicity this blog post has one such sample zip file which you can import. Please note for now this contains only tables definition and no views definition. You can download the zip file from here
P.S: Until the system is upgraded to HANA 2.0 you can only use this sample zip file to create the calculation views in SAP HANA Web IDE. The Tables/Views exported from current SAP Marketing cloud -> Add Custom Views Application will not work as they are still on HANA 1.0.
Once the zip is downloaded you can import the same into workspace.
Explore the imported project and go to hdbtables folder and then select build.
The build process would look as below in the console and you can also see success message.
Upon successful build, a new HDI container would be created which you can also explore in Database explorer which can be selected from the side menu.
From the file explorer you can create a new calculation view.
You can give details for new calculation view an example as below.
Once you have designed the custom view as per your requirement you can build the view. Upon successful build then the view would get deployed successfully.
Upon successful deployment and build, you can decide to export the view and import into SAP Marketing Cloud.
Rename the extension of the file from “.hdbcalculationview” to “.xml” and save.
Once the Application SAP Marketing Cloud is on HANA 2.0 you would be able to import this view into SAP Marketing Cloud using “Add custom View” Application using Import View Definition for the views.
Happy building Custom Views on HANA 2.0.