Healthcare data puzzle

• ajenawsu

  Mr or Mrs. 500

  Points: 558

  More actions

  November 14, 2011 at 10:34 am

  #150676

  I'm having a heck of a time with this one. Each of our doctors (providers) has a panel of patients who are assigned to them. They also see patients who are assigned to other doctors. Each month we want to show:

  1) how many patients were assigned to them

  2) how many encounters they had (for their patients as well as other providers)

  3) how many patients they saw (the encounters above)

  In my DSV I have a FactEncounter table, and DimPatient, DimProvider, and DimDate tables.

  FactEncounter -> DimPatient, DimProvider, DimDate

  DimPatient -> DimProvider

  For #1 above the patients assigned to them must have been seen by someone within the time period.

  I'm not sure where I'm going wrong but I can never get the numbers to come out right.

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  November 14, 2011 at 11:00 am

  #1407425

  Can't help without seeing the code.

  And since this is most likely mdx, can't help at all.