Thanks for your response.

Yes. Original Fact visit still hold some information. Problem is, new facts I am trying to bringing in have different granularity.

For each visit, patient could have multiple lab tests, orders and procedures, and customer wants to see the per visit per transaction level data (so first look at the visit level info, then drill across all the relevant lab, medicine, procedure).

Initially, I added all transaction level fact attribute to old FactVisit table and changed granularity level. But we have some calculated values for visitLevel, and if patient have multiple transaction action, this visit level value would get repeated multiple times (sometime over 100 times!).

So, I went through some books and came up with new design 🙁