Gerry,

Thank you for the reference. I'll look into the book.

Putting aside the example (which was a construct soley to illustrate the question) what is your opinion of the concept of a dimension in one star being a fact table in another? Do you have, or have you come across, any opinions that support or derail it as a logical design concept?

Thanks,
Isabel