Lab Result values in Fact Table has int and non int values

View previous topic View next topic Go down

Lab Result values in Fact Table has int and non int values

Post  sqlkiller on Fri Dec 30, 2011 12:18 pm

Hi Everyone,

I am struggling to find a way out for my problem with clinical data mart where i have 3 dimensions and one fact table

Dimension tables are --<1. Patient, Provider, Lab_tests

Fact Table is --> 1. Fact_labresult

My fact table looks like below image which has lab result values which are not perfect measures or int values.

can any one suggest me a best method how to represent this lab values in my fact table. Do i need to use degenerate dimension but this lab values are about 88,000000 rows of data.

Please suggest me what to do, if i convert it to int , i will loose the data which is of the form Negative,>somevalue etc..

sqlkiller

Posts : 2
Join date : 2011-11-17

View user profile

Back to top Go down

Fact Dimension

Post  BrentGreenwood on Sat Dec 31, 2011 3:26 pm

This exact scenario is covered in Kimball's DW Toolkit. In the Healthcare chapter (13, p.269). Fact Dimension for Sparse Facts. Also covered in the Reader (8.24 & 8.25).

Essentially you can use an additional dimension to signify what type of measure your measure is. And store textual values off the fact table in a separate dimension.

Hope this helps.

BrentGreenwood

Posts : 6
Join date : 2011-12-25
Location : San Diego, CA

View user profile http://brentgreenwood.blogspot.com

Back to top Go down

Re: Lab Result values in Fact Table has int and non int values

Post  sqlkiller on Mon Feb 06, 2012 5:15 pm

Thanks a lot!
This helped me, i was able to build the cube and customer is really happy.

sqlkiller

Posts : 2
Join date : 2011-11-17

View user profile

Back to top Go down

Re: Lab Result values in Fact Table has int and non int values

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