1 Reply Latest reply: Jan 22, 2010 5:18 AM by Christian Berg RSS

    SIL_ListOfValuesDimension does not capture changes


      I have issues with the mapping SIL_ListOfValuesDimension - it seems not to process updated records, but only to insert new records. Hence whenever we e.g. change the DESC_TEXT or LOW value of an LOV record, it is not updated to W_LOV_D.

      Reason is, that the mapping applies a filter ISNULL(LKP_ROW_WID). Exact porcess is

      - Lookup on W_LOV_D - condition on VAL, TYPE and NAME. Return ROW_WID
      - Filter: ISNULL(LKP_ROW_WID)
      - Another Lookup on W_LOV_D - condition only on TYPE AND NAME. Return ROW_WID

      I am now planning to change this filter to make it process also existing records and pass updates - however I am worried that this might have side-impacts - since I do not fully understand the background and reason for the abvoe procedure with the 2 consecutive lookups.

      Any experience with this issue? Any recommendations how to proceed?

      Edited by: user4594204 on Jan 19, 2010 12:12 AM

      Edited by: user4594204 on Jan 19, 2010 12:12 AM