newbie question re many-to-many fact modelling
- From: deja@xxxxxxxxxxxx
- Date: 17 Jan 2007 05:48:54 -0800
hi,
brand new to OLAP. Trying to model my reporting database. I have:
Shows
Rooms
Attendees
Presenters
TimeSlots
A show could have many timeslots (consecutive - start to end), could be
arranged over many rooms (not distinguished by timeslot), could have
many attendees and many presenters.
A room could hold many shows simultaneously (in theory).
If I want to be able to report for example on:
Show all rooms by timeslot - being used or not?
Show all rooms by timeslot - number of attendees?
Show all presenters by timeslot - number of attendees?
Show all presenters by show_type - number of attendees?
Show all presenters by show type - number of timeslots per week
If I make my Fact table:
ShowId,
TimeSlotId,
RoomId,
PresenterId,
NumberofAttendees
then if the show has 2 presenters and I then want to use my Room
dimension - I will get a double count. I'm not really sure how I should
be modelling. Do I use 2 different fact tables one that has
ShowId,RoomId,TimeSlotId and NumberofAttendees and another that has
ShowId,PresenterId, TimeSlotId, NumberofAttendees. But then
NumberofAttendees is actually an attribute of the Show....
Anyone point me in the right direction? (using Analysis Server 2000 but
could potentially move to 2005 if 2000 doesn't have the functionality)
thanks
Phil
.
- Follow-Ups:
- Re: newbie question re many-to-many fact modelling
- From: Deepak Puri
- Re: newbie question re many-to-many fact modelling
- Prev by Date: Re: HELP I am about to quit on AS2005
- Next by Date: Re: newbie question re many-to-many fact modelling
- Previous by thread: Re: Newbie Question on Measures
- Next by thread: Re: newbie question re many-to-many fact modelling
- Index(es):