I have a data modeling question regarding patient diagnosis and hospital procedures that I can’t get to work. Each patient can have up to 10 diagnoses and 10 procedures per stay. I need to build a data mart that allows the user to count the number of times a procedure occurred for all patients within any of the 10 recordings for any diagnosis combination. I tried a schema that has a Time Dim, Hospital Dim, Dimensions for each diagnosis, Dimensions for each procedure and a count in the measure table for each diagnosis and each procedure.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access