Build and import SAP HANA Views for Segmentation in Hybris Marketing Cloud
With Hybris Marketing Cloud you are able to import own SAP HANA Segmentation Views by using the SAP Fiori App “Add Custom View”. This blog will tell you which steps you need to carry out to build and import your own views using your own SAP HANA Database.
Prerequisite: SAP HANA Database with Schema ABAP
In order to build SAP HANA views for segmentation you need an SAP HANA Database with schema ABAP. You can create yourself a SAP HANA Database in your SAP HANA Cloud Platform (HCP). If you do not have puchased a licence, you can also use the Trial Account like used in this blog post. See blog post Setup of SAP HANA Database in SAP Hana Cloud Platform Trial Account to build Segmentation Views for Hybris Marketing Cloud on how to setup your SAP HCP account accordingly.
Prerequisite: SAP Fiori App “Add Custom Views”
SAP Hybris Marketing Cloud offers the SAP Fiori App “Add Custom Views”. The app is part of business catalog “Extensibility – Marketing” (SAP_CEC_BC_MKT_EXT_PC) and business role template “Administrator – Marketing” (BR_ADMINISTRATOR_MKT).
Prerequisite: SAP Standard Tables
You have already exported the SAP standard tables from your Hybris Marketing Cloud System and imported them into your SAP HANA Database as explained in blog post Export SAP HANA Views from Hybris Marketing Cloud
Create your own SAP HANA View and export SAP HANA Repository XML
- Create your own graphical calculation view in your SAP HANA Database on top of the ABAP tables or SAP delivered HANA views. Keep in mind the constraints for importing the SAP HANA View later on in S/4HANA Marketing Cloud.
- You have to export the repository XML of your SAP HANA view. To export the repository XML press the corresponding button in the right upper corner.
- On the upcoming popup press Save As and save the XML to your local machine:
Import your own SAP HANA View for Segmentation into SAP Hybris Marketing Cloud