Skip to Content
Technical Articles

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.

 

6 Comments
You must be Logged on to comment or reply to a post.
  • Nice Blog Latha, thank you! 🙂

    Maybe it would be good to use also the SAP Marketing Cloud tag, so that makes it easier to find.

    Two questions:

    1. Is it also possible to create tables with the table_def.txt we get out of Marketing Cloud at the moment?
    2. Can we also import and use/model the calculation Views right now? Because the export gives us .calculationview files and not .hdbcalculationview files.

    I would much appreciate more Blogs like that concerning Extensibility for SMC!

    BR Tobias

    • Hi Tobias,

       

      Sorry I was not following the page hence hence missed to see your comment.

       

      At the mmoment since SMC system is still on HANA 1.0 you can perform avtions which you have put in the questions. Post upgrade of HANA DB you will be able to export HDB tables and .hdbcalculationview files.

       

      I also added the note later on the blog.

      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.

       

      Regards,

      Latha

       

  • Hi Latha thanks for sharing this.

    Before the step of building I’ve created a SAP HANA instance in my Cockpit trial, because I started a trial account from scratch, and when trying to build the hdbtables I’m getting this error:

     

    What am I missing here?

    Do I need to add a SAP HANA Service Connection before building the hdbtables?

     

    Kind regards,

    Ubeimar

    /