Skip to Content
0

Changing the Object_type on a record within CUAND_CE_IA_PROD Hybris Marketing

May 24, 2017 at 02:04 PM

74

avatar image
Former Member

Hi,

So the scenario we have is that we have a load of interactions which have been loaded into our Hybris Marketing on-prem system (1611). These interactions also have products on them so it is also populating the table CUAND_CE_IA_PROD. However whilst building our ODATA service we didn't load the correct "OBJECT_TYPE" against the interaction. We later changed this to the correct object_type however the old data is influencing our Recommendation Model. We need to change this on the record so that our predictive models and scores actually start showing some meaning for a demo.

Is there a simple way of changing this by writing an SQL script in HANA for this table or are more table impacted.

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

1 Answer

Best Answer
Saurabh Kabra
May 24, 2017 at 05:55 PM
1

Hi,

You can write a HANA SQL query to update the Content. But while updating you have to make sure that table

CUAND_PROD_FACET field PRODUCT_ORIGIN is also updated.

Here CUAND_CE_IA_PROD-PRODUCT_KEY = CUAND_PROD_FACET-PARENT_KEY

Thanks

Saurabh

Share
10 |10000 characters needed characters left characters exceeded