Skip to Content
avatar image
Former Member

Changing the Object_type on a record within CUAND_CE_IA_PROD Hybris Marketing

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 24, 2017 at 05:55 PM

    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

    Add comment
    10|10000 characters needed characters exceeded