Skip to Content
avatar image
Tobias Schneider

Hybris Marketing HANA Tables Usage

Jun 27, 2017 at 07:06 AM | 475 Views

Dear Experts,

is there an overview of the tables that are used by the different apps in Hybris Marketing. I've seen the list of the replicated ERP tables in the Installation & Configuration Guide (20.2), but I don't know which data of these tables goes into which other tables and are used for which app.

For Example: In the SAP Hybris Marketing Cloud trial version the number of profiles is the same in the profile dashboard. But in my yMkt on-prem version the number of the profiles doesn't correspond to the number in the profile dashboard. So I think the profile dashboard makes use of other tables..

Until now I only know that the CUAND_CE_IC_ROOT, CUAND_CE_IC_FT_D and CUAND_CE_IC_FCET tables are used.

Can anyone help?

Thanks and regards

SAP Marketing
SAP HANA studio
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Maik Offerle
    Jun 30, 2017 at 04:20 PM

    Hi Tobias,

    you can find the Hybris Marketing Tables in the Content Folder of your Hana Studio and there in respective Schema of Hybris Marketing. Just use the Hana Studio filter function and search for CUAN. This indicates a Hybris Marketing table.

    But most of the UIs are more based on Hana Views than Hana Tables. See most of the Standard Hana Views in your Hana Studio content folder and then go to: sap.hana-app.cuan

    Best regards

    Maik

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Stefan Nasshan
    Jul 03, 2017 at 07:52 AM

    Hi Tobias,

    yes sometimes there are different views used. The profiles app for example does not use a HANA view at all but a CDS query. So it is difficult to directly compare where any differences might come from. However, Profiles and Profile Dashboard deliver different views on the contact data so slight differences are normal.

    Best regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

    • Stefan Nasshan
      Jul 10, 2017 at 02:23 PM

      The Profile Dashboard provides mainly a view on contacts and allows to narrow that view with criteria like interests, channels and so on. The goal can e. g. be to create a Target Group.

      The Profile OWL provides a view on profiles which is a combination of a contact and his/her last interaction, enriched with scores. So you can't really compare the two screens.

      That's why the numbers can differ. We would have to investigate where in your case the different numbers come from, but it can be due to different timeframes selected, timezones, different interactions taken into account and so on. For example, for the Profile only Inbound interactions are used, but for the Profile Dashboard, also outgoing interactions are valid. This can then lead to diffirences.

      Why do you have the need to have identical counts for both screens?