Hi All,

While doing BI configuration for warehouse Domain values, instead of editing the OOTB source warehouse range domain values we have added new Domain value/code set. Which has resulted in multiple warehouse domain for a domain code.

For E.g., For POW(Period of Work) warehouse domain, instead of editing the OOTB domain value code 0<11(yrs),EMP_POW_1, we have added another custom warehouse domain code 0<12,WTW_EMP_POW_1.

Which has resulted into multiple domain value/code pair in W_DOMAIN_MEMBER_G and W_DOMAIN_MAP_G tables, which in-turn resulted into unwanted rows into all the range dimension tables like W_PRD_OF_WRK_BAND_D.

Any pointers how this can be corrected, we can change the Domain values in BIACM and run the domain load, but since in our warehouse we have data from multiple sources I cannot reset the warehouse, also after doing correction and running Domain load in incremental mode I am not sure it is going to delete those unwanted rows from DOMAIN tables and from Dimension tables.

Thanks,

-Saurabh