newbie question re many-to-many fact modelling



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

.