Welcome to the blog post of the Expert Services Marketing Practice.
We are happy to share our experience with you around Marketing Integration, Analytics, and Business Technology.
You want to see more blogs from Expert Services? Click here
Table of Content
Customers who have very specific requirements for Segmentation, Scores or Recommendations in SAP Marketing Cloud sometimes need to create custom views for HANA modelling.
In the past this was done via Eclipse (including HANA tools) and you needed time to setup the whole environment, communication to the database and more. Nowadays you can do it purely in a ready to play cloud environment through SAP Cloud Platform.
In this blog article I will describe an approach how to do HANA modelling on SAP Cloud Platform and how to add a custom view to SAP Marketing Cloud.
This approach will save time, costs and makes collaboration between colleagues easier.
For the approach via Eclipse have a look at those really nice blogs:
Ensure your SAP Marketing Cloud is ready. For general information about custom views in SAP Marketing Cloud have a look at the documentation here.
Ensure your SAP Cloud Platform (Trial Account) is ready. Please follow the guide here
For this Blog Post following product release version has been used.
|SAP Marketing Cloud||Release: 1808||
|SAP Cloud Platform (trial)||November 2018 version||
What’s new section/ Release Notes:
Since we have short release cycles, the content in this blog post might look different from what you find on your SAP Marketing Cloud and SAP Cloud Platform (Trial) system.
SAP Marketing Cloud: Quarterly releases
SAP Cloud Platform: different release cycles for services
Step 1: Create a HANA database on SAP Cloud Platform
Logon to you SAP Cloud Platform Cockpit and create your SAP HANA database. For a detailed documentation have a look here.
Just create the database with the standard settings like visible in the screen below.
Wait until the database is successfully created and and click on the name of the HANA database like below:
Step 2: Add sufficient user rights for SAP Cloud Platform HANA web UI
After the successful creation of the database we want to start HANA modelling. But to be able to do this we have to enable some settings.
First click on the SAP HANA Cockpit link and login via the SYSTEM user and the defined password.
This will trigger the assignment of necessary roles to your SYSTEM user (like you see in the popup below) and is necessary for the next steps.
Next click on OK and continue and after this you will see the SAP HANA Cockpit of your database.
But still our user is not ready to use the SAP HANA Web-based Development Workbench Editor and Catalog functionality which is mandatory for HANA modelling in the cloud.
So we have to add those roles. See the predefined HANA Web-based Development Workbench roles as a reference here.
We will add the roles for “sap.hana.ide.roles::CatalogDeveloper” and “sap.hana.ide.roles::EditorDeveloper” to our user.
Note: These are the roles for our use case and role/ user assignment needs to be evaluated on project basis. Refer to the link above.
Click on the “Manage Roles and Users” tile in the SAP HANA Cockpit of your database which is highlighted in the screen above.
Under User –> SYSTEM add those two roles through the plus button to your user. After this Save your changes (e.g. via Ctrl + S).
After this the SYSTEM user is able to open the editor and catalog of the SAP HANA Web-based Development Workbench.
The last step for modelling preparation is to create an ABAP schema in the HANA database catalog IDE as this is required by SAP Marketing Cloud.
As SAP Marketing Cloud always works with this schema name and we will export all table SQLs for this ABAP schema.
Open the catalog and execute the following statement via the SQL console.
CREATE SCHEMA ABAP; GRANT SELECT ON SCHEMA ABAP TO _SYS_REPO WITH GRANT OPTION;
This will create a new schema “ABAP” and the schema should be visible after refresh like in the screen below.
Step 3: Custom view modelling in SAP HANA Web-based Development Workbench
After the previous steps the environment is ready and we can start modelling.
Some restrictions apply for SAP Marketing Cloud custom views which can be found here and will be checked during import of the custom view later on.
This means for example that for segmentation we always have to provide the technical identifier (e.g. CONTACT_KEY) of the interaction contact in the semantics node of our custom view and have to add specific tables like e.g. CUAND_CE_IC_FCET.
To export existing views/ tables from SAP Marketing Cloud which are necessary for your modelling project use the SAP Marketing Cloud App “Add Custom Views”. In this example below I will export the CUAND_CE_IC_FCET table as this is necessary for my project (1.).
Import the table definitions via SQL Console in SAP HANA Web-based Development Workbench Catalog like below (2.) and the table should appear (3.).
If all the necessary tables or views are imported we can start modelling via the SAP HANA Web-based Development Workbench Editor.
See an example of a custom view below which is adding the corresponding landing page name where a contact originates from to Segmentation. Here we used the CUAND_CE_IC_FCET table exported before along with other tables.
To import this view via the app “Add Custom Views” in SAP Marketing Cloud we have to save the view first as XML. To do this right click on the view and use Open With –> Text Editor (1.). This will open a new tab with XML data (2.).
Copy this XML representation of the HANA view and save it as XML file to your local computer. After this import this file via the app “Add Custom Views” in SAP Marketing Cloud like in the screen below.
SAP Cloud Platform
SAP Marketing Cloud
In this blog post, you learned how to do easy HANA modelling for SAP Marketing Cloud purely via browser based web UIs. This enables you to jump-start your implementation projects and saves time and money.
You want to see more blogs from Expert Services? Click here
Your SAP Expert Services – Marketing Practice team.