Summarized data with detail

View previous topic View next topic Go down

Summarized data with detail

Post  chade25 on 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 : 37
Location : Oregon

View user profile

Back to top Go down

RE: Summarized data with detail

Post  rathjeevesh on 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

View user profile

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