When upgrading from Oracle Business Analytics Warehouse version 7.5.3 to version 7.7, duplicate rows are inserted into a mini dimension table from the dimension table.

Before upgrading, all leading and trailing spaces need to be removed from the data.

1. Before running the workflow for the mini dimension that appears in the upgrade folder, modify the data to remove leading and trailing spaces by using the RTRIM and LTRIM functions. For example: set(col)=rtrim(col)
2. In cases where you find leading and trailing spaces, modify the SQL override for the mini dimension mapping in the main folder as shown in the example below:

SELECT DISTINCT
     CASE WHEN G1.VAL IS NULL THEN RTRIM(LTRIM(DS.AREA)) ELSE G1.VAL END AS AREA,
     CASE WHEN G1.NAME IS NULL THEN RTRIM(LTRIM(DS.AREA)) ELSE G1.NAME END AS AREA_I,
     CASE WHEN G2.VAL IS NULL THEN RTRIM(LTRIM(DS.SUB_AREA)) ELSE G2.VAL END AS SUB_AREA
     CASE WHEN G2.NAME IS NULL THEN RTRIM (LTRIM(DS.SUB_AREA)) ELSE G2.NAME END AS SUB_AREA_I
     CASE WHEN G3.VAL IS NULL THEN RTRIM(LTRIM(DS.SEV_CD)) ELSE G3.VAL END AS SEV_CD
     CASE WHEN G3.NAME IS NULL THEN RTRIM (LTRIM(DS.SEV_CD)) ELSE G3.NAME END AS SEV_CD_I
     CASE WHEN G4.VAL IS NULL THEN RTRIM(LTRIM(DS.PRIO_CD)) ELSE G4.VAL END AS PRIO_CD
     CASE WHEN G4.NAME IS NULL THEN RTRIM (LTRIM(DS.PRIO_CD)) ELSE G4.NAME END AS PRIO_CD_I
FROM
     W_SRVREQ_DS DS,
     W_LOV_G G1,
     W_LOV_G G2,
     W_LOV_G G3,
     W_LOV_G G4
WHERE
     W_SRVREQ_DS
     LEFT OUTER JOIN V_LOV_G G1 ON
         DS.AREA = G1.NAMEVAL AND
         G1.TYPE = 'SR_AREA'
     LEFT OUTER JOIN W_LOV_G G2 ON
         DS.SUB_AREA = G2.NAMEVAL AND
         G2.TYPE = 'SR_AREA'
     LEFT OUTER JOIN W_LOV_G G3 ON
         DS.SEV_CD = G3.NAMEVAL AND
         G3.TYPE = 'SR_SEVERITY'
     LEFT OUTER JOIN W_LOV_G G4 ON
         DS.PRIO_CD = G4.NAMEVAL AND
          G4.TYPE = 'SR_PRIORITY'}