Technical Articles
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
- Open the app Add Custom Views.
- Select tab Import View.
- Select your repository XML and press Import View.
- Your view is imported into an own folder under sap.hana-app.cuan.custm_seg.gen. You can now add the view to your segmentation.
Dear Eileen,
thank you for this blog. We have exported a View that was created when creating a Custom Business Object. The export was done to change the labels of this view as only the ID appeared in Segmentation and no description.
Now we would like to import this view again to overwrite the existing view. How this can be done?
In the blog you have connected the yM Cloud to the SAP HANA Studio? Is this generally speaken possible? I was thinking that the views have to be exportet and imported without being able to directly connect the cloud system to SAP HANA Studio?
Cheers,
Hi Eileen,
I'm getting below error while importing the calculation from HANA studio to Marketing Cloud.
This is the calculation view I have created and trying to import
Dear Govinda,
please create a ticket on component CEC-MKT-EXT.
Best regards,
Eileen
Dear All,
We are currently struggling to make our custom view available for segmentation. We have already check our custom view multiple times and cannot find anything that is missing.
Our use case is merging two datasources (CUAND_CE_IC_TM and our CBO YY1_****) we have identified our join attribute (EmployeeID) and joined both datasources. We use a left-outer and have already tried 1.1 and n.m cardinality.
Our overall view looks as followed:
However when we enable it for segmentation the attributes remain empty. Ff we create a CDS view we can see that the values are filled up and should be joined based on the employee ID.
Any recommendations on what we should check?