I am working on a hospital billing model. Charges, Payments, Adjustments, Episodes, all by doctor, patient, financial class, etc.
What I have so far -
FactAR_Transactions - payments, adjustments, etc
FactEpisode - the actual admission event
and other Dims
I'm stuck on episodes. At times, an episode seems like a dimension and a fact. For example, sometimes we look at Payments by Episode. The Episode fact grain does not include payments, nor does FactPayments include episodes. An episode is an event, right? So I figured it was only to be a fact.
So if we have FactPayments and FactEpisodes, how would I get to Payments by Episode? This is where Episode seemed like a dimension needed in the grain of FactPayments.
I have no problem creating an Episode Dim, but I just wondered if I'm missing something in a drill-across method or some way to bring payments and episodes together when FactPayments doesn't include episodes?
Thank you for any help!