Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Shoulddd i use multiple fact table in this case

2 posters

Go down

Shoulddd  i use  multiple fact table in this case Empty Shoulddd i use multiple fact table in this case

Post  sathwik.uc1@gmail.com Fri Apr 10, 2015 6:57 pm

I have  dimensions namely  Patient,staff,plan of care,therapy,date dimensions, insurance  and fact table  revenue and morover  1  plan of care can lead to  many therapies and  patient can  admit as many times should i use multiple fact table??

Please let me know if my question is not proper??

sathwik.uc1@gmail.com

Posts : 2
Join date : 2015-04-10

Back to top Go down

Shoulddd  i use  multiple fact table in this case Empty Re: Shoulddd i use multiple fact table in this case

Post  ngalemmo Sat Apr 11, 2015 4:43 pm

Maybe, maybe not. What does the fact table represent?
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Shoulddd  i use  multiple fact table in this case Empty reply for question

Post  sathwik.uc1@gmail.com Sun Apr 12, 2015 12:51 pm

Fact table represent diagnosis charge and therapy charge measures and the otherwarehouse keys...Please suggest me the appropriate model

sathwik.uc1@gmail.com

Posts : 2
Join date : 2015-04-10

Back to top Go down

Shoulddd  i use  multiple fact table in this case Empty Re: Shoulddd i use multiple fact table in this case

Post  ngalemmo Mon Apr 13, 2015 10:38 am

Grain, measures and timing usually determine what goes into a fact table. For example, you have charges related to procedures and facilities. It is common that these are represented by two different facts because they are at different levels of detail (grain). Diagnosis is usually a multi-valued dimension supported by a bridge.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Shoulddd  i use  multiple fact table in this case Empty Re: Shoulddd i use multiple fact table in this case

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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