Oracle Analytics and AI

User_WDAK8

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

Venkata Yaswanth Ramisetty

Hi Saurabh,

In this case, I think you will have new band values in DOMAIN_MEMBER_G table. That's fine as you have added them. But as you mapped only your custom values to source values, only those entries should be there in DOMAIN_MEMBER_MAP_G. Can you check your MAP_G table and show us once the table and the BIACM for the same.

Thanks,

Yaswanth