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

Summarized data with detail

2 posters

Go down

Summarized data with detail Empty Summarized data with detail

Post  chade25 Tue Mar 19, 2013 10:39 pm

My example is this: Storing registration event for students at a university, then having columns to say their institutional GPA up to that point of the event, Overall GPA up to the point of that event and their GPA for just that term they registered for (when grades show up ). Is this bad to do? Is it bad as well to join this detail fact table to a summary fact table which would have the sum of the persons Credit hours earned that was transferred from another institution?

Thanks guys.

chade25

Posts : 29
Join date : 2012-04-12
Age : 44
Location : Oregon

Back to top Go down

Summarized data with detail Empty RE: Summarized data with detail

Post  rathjeevesh Mon Mar 25, 2013 12:23 am

We are advised to store data in a fact table that conform to the grain of the fact. Mixing summary and detail data together impose query challenges and consistency in output.

"having columns to say their institutional GPA up to that point of the event, Overall GPA up to the point of that event" is ok to store along with registration fees etc. "their GPA for just that term they registered for" once the term is over then you have to update the value in the fact and that is ok too.

There is no problem joining a details fact with summary fact table as long as you have conformed dimension to resolve the join path.

-JR

rathjeevesh

Posts : 15
Join date : 2013-02-16

Back to top Go down

Back to top

- Similar topics

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