Appreciate Steve for your quick input. So there are no way of walking around, right? I think this phenomenon is very normal since in most fact table design, we allow some value (like -1) to represent unknown keys. If they will be aggregated into one row (if other keys are same), this will generate incorrect data calculation when rolling up, without being detected (like in this case). Am I right?

Thanks again for your quick reply, Steve.