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

Hierarchies in dimensional modeling

2 posters

Go down

Hierarchies in dimensional modeling Empty Hierarchies in dimensional modeling

Post  exhortae Sun Aug 01, 2010 5:13 pm

Hi,



I have a little problem modeling hierarchies for a data mart.

Lets say I'm building a datamart for students grades in a university. In this university you have units of teaching and each unit of teaching (UT) is composed of one to many courses (Course). The fact table is composed of student's grades in courses.

What is the difference between those two ?
- Make two dimension 1 is dim_unit_of_teaching et 2 is dim_course.
- Make a flat dimension with a column unit_of_teaching and a column course


I guess if I go with making two dimensions I'm loosing the hierarchy, am I right ?

Thank you


PS : excuse me for my english.

exhortae

Posts : 30
Join date : 2010-08-01

Back to top Go down

Hierarchies in dimensional modeling Empty Re: Hierarchies in dimensional modeling

Post  ngalemmo Mon Aug 02, 2010 11:53 am

If a course can only belong to one unit of teaching (I'm assuming you mean Department or College), then the flat option, storing unit of teaching as an attribute of the course is the simplest solution. But, doing so does not mean you would not have a unit of teaching dimension for other purposes.

If, on the other hand, your are classifying courses based on requirements for a Degree, then it is essentially the same thing as a Bill of Materials and needs to be handled by a hierarchy bridge.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Hierarchies in dimensional modeling Empty Re: Hierarchies in dimensional modeling

Post  exhortae Wed Aug 04, 2010 12:04 pm

Hi,

In a french university system, the year is divised in two semesters, in each semester you have several units of teaching (several courses are grouped in a unit of teaching).

Like MAX45 would be a unit of teaching named Mathematics which is composed of 3 courses
-Geometry
-Arithmetic Analysis
-Probabilities


By hierarchy bridge you mean some kind of recursive relationahsip like in a parent child relation? if it's yes it's not the case here.

Thanks

exhortae

Posts : 30
Join date : 2010-08-01

Back to top Go down

Hierarchies in dimensional modeling Empty Re: Hierarchies in dimensional modeling

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