days of hospitalization as a "dynamic Measure"

View previous topic View next topic Go down

days of hospitalization as a "dynamic Measure"

Post  nickall on Fri Jan 15, 2010 1:49 pm

Hi gurus!
I'm working on some clinical data.
I'm dealing with hospitalizations, and one of the measures that i'd like to use is: Days of hospitalization, with an obligation:
Suppose that an hospitalization starts on 15th december 2008 and ends on 15th January 2009: a total of 30 days of hospitalizations,
but I'd like to group the first 15 days (15th december 2008 - 31st december 2008) in the 2008, and the second 15 days (1st January 2009 - 15th January 2009)
in the 2009.
I've already implemented two shared dimensions that handle dates: one for date start and one for discharge date.
Is there a way to meet this business requirement?

Tnx for reading!

nickall

Posts : 5
Join date : 2009-12-10

View user profile

Back to top Go down

Re: days of hospitalization as a "dynamic Measure"

Post  ngalemmo on Mon Jan 18, 2010 4:42 am

You should be able to calculate it on the fly, but it would be a bit tricky... First, it would help if your date dimension contained a day of the year value and number of days in the year. To handle stays split over years, you need two passes through the facts (UNION). The first to calculate the number of days from admission to either the end of the year or discharge which ever comes first. Then a second pass for those fact where the discharge date is in the next year to calculate the number of days from the beginning of the year to the discharge.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: days of hospitalization as a "dynamic Measure"

Post  D_Pons on Tue Jan 19, 2010 6:05 am

I guess this might depend on volumes and also on the tools being used, but would it make the queries easier if the grain of the fact were one row per patient, per hospitalization, per day?

D_Pons

Posts : 16
Join date : 2009-02-10
Location : UK

View user profile

Back to top Go down

Re: days of hospitalization as a "dynamic Measure"

Post  VHF on Wed Jan 20, 2010 7:07 pm

Yes! That would certainly make counting days of hospitalization easy. Have a 'HospitalizationDays' measure in the fact table that is always set to 1 for each fact record. No matter how you aggregate the fact data you will get a correct total.

(There are still some queries that are tricky and could require multiple passes, for example "how many patients did we have in December that had a stay of 30 days or longer?")

VHF

Posts : 236
Join date : 2009-04-28
Location : Wisconsin, US

View user profile

Back to top Go down

Re: days of hospitalization as a "dynamic Measure"

Post  Sponsored content


Sponsored content


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