Episode, Item modelling,

View previous topic View next topic Go down

Episode, Item modelling,

Post  MJ on Fri Oct 22, 2010 3:06 pm

A general DM question for modelling Episode and Item data within health models. This question may more broadly relate to general Header and Item analysis in other non health models.
Our requirements are for both,
1. Episode analysis - Length of Stay, DRG, Admission date, Discharge date, Episode cost, Provider etc.
2. Item analysis – Episode, Number of items, Item cost, Provider, Service date etc.
Due to the differing grain of the requirements we expect 2 facts will be created, an Episode fact and an Item fact.

Our question is how best to create the relation between the two process models to facilitate the Episode relationship?

Is the simple answer to create an Episode dimension which contains a managed Episode ID. If this is the case we end up with an Episode dimension growing at the same rate as the Episode fact and a tendency to move the Episode Admission date, Discharge date and other Episode attributes to the dimension rather than resolving these in the Episode fact.

We’d be keen to hear other’s view on this scenario.

MJ

Posts : 5
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Episode, Item modelling,

Post  ngalemmo on Fri Oct 22, 2010 5:09 pm

"Our question is how best to create the relation between the two process models to facilitate the Episode relationship?"

By not creating a relationship between the two process models.

Simply carry dimensional FK's in the item table that would also be found in the episode table. Treat episode ID as a degenerate dimension.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum