In DW_MATERIAL_MASTER a material may has an entry for JMNZ but not JMAU.
If there is a JMAU transaction for this material, when extracting the fact data against the dimension (material hierarchy), this transaction maybe dropped from the fact table since it could not find the correspond entry in material hierarchy.
For a JMNZ transaction, it might be labeled as UNALLOCATED JJMAU as its EMPLOYEE_NAME_DISPLAY.
Such transaction may have gone into JMAU (appears in JJM Affiliates) cube instead of JMNZ cube.
No comments:
Post a Comment