0 Replies Latest reply: Dec 30, 2012 10:57 PM by nk9 RSS

    Impact on OBIEE reports after extending integration_id in w_purchg_card_F

    nk9
      Hello All,

      We have recieved two records with same merchant_id thus identified as dupes while creating unique index and failed
      so we queried those two records in source and it appears the two records are unique on line_br 0 and 1
      so we are now extending integration_id with concatenating line_br into integ_id

      index is built on integ_id

      so the records now will be unique and loaded

      what will be the impact on OBIEE reports which use w_purchg_card_f ??
      will it change granularity?

      as we have changed the defintion of natural key integ_id by adding extra column line_nbr

      i am assuming change in integ_id of Dimensional warehouse tables will impact reports as they are basis for doing lookup and establish Fact and dim
      relationship F.ID = D.integ_id ---> D.row_wid ------> F. WID

      So can anyone answer if

      1)what will be the impact on OBIEE reports which use w_purchg_card_f ??
      will it change granularity?

      2) will integ_id of FActs are used in building any imprts

      3) what is impact of changing index on imports

      4) which impact is more on reports , having dupe records or changing integ_id of fact table?




      Thanks