Skip to Content
0

Hybris Marketing HANA Tables Usage

Jun 27, 2017 at 07:06 AM

200

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Maik Offerle
Jun 30, 2017 at 04:20 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Maik,

I found the tables and views in HANA Studio. But I thought that the apps "Profiles" and "Profile Dashboard" should use the same views/tables? In the SAP Hybris Marketing Cloud Trial the apps show the same number of profiles. But in my on-prem version I have two different numbers of profiles for the apps. That's why I asked for an overview of the views that are used by the different applications.

Do you know if or how it is possible to configure the data sources for the applications? In customizing it's only possible to change the data source for segmentation I think.

Thank you & best regards

Tobias

0

Hi Tobias,

it's not possible to customize this.

Best regards

Maik

0
Stefan Nasshan
Jul 03, 2017 at 07:52 AM
0

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

Show 4 Share
10 |10000 characters needed characters left characters exceeded

Hi Stefan,

thank you for that information.

It seems like in my case the app "profile dashboard" is using the same view/cds query/table that the app "contacts" uses.

Is it possible to change these data sources?

Best regards

Tobias

0

Hi Tobias,

the Contact OWL, Profiles app and Profile Dashboard UI all use different ODatas with different views/data sources in the backend. Each UI has a different purpose and therefore, the data sources are different. It is not possible to switch the data source as the UIs are adapted to the corresponding OData with its properties and so on.

What's the issue with the current data sources, just the slight differences in numbers or are you missing functionality`

Best regards

Stefan

0

Hi Stefan,

the problem is, that the Profile Dashboard doesn't show the number of profiles but the number of contacts and I don't know why. In the SAP Trial the numbers in the apps "Profile" and "Profile Dashboard" are identical.

Best regards

Tobias

0

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?

0