I'm fairly new at datawarehousing.


I got the following layout in the relational database:

- A table containing people
- A table containing begin and enddates of agreements together with the
sort of agreement (10 types) every row linked to a person.
- A table containing begin and enddates and the location of the persons.


Is this the correct way to go:

I create a TimeDimension with all the dates.
I create People, Agreement and Location dimensions.
I create a fact table that contains: date, person, agreement, location

So the fact table will have a row for every date and every person.
People can only have 1 agreement and location on any time.

The information I need is to know how many people are in which caregory
(and or location) during a certain period, or on a certain date.

Is this the correct way to do it? I think the people dimension might
be too much for this need.

--
Thanks in advance,

Stijn Verrept.