DanUp wrote:
> Hello,
>
> Although I'm familiar with Kimball Group methods for DW modelling, I am now
> in search of a more specialized learning resource (preferably a leading book,
> but perhaps also a blog or website) that covers dimensional modelling best
> practices (in relational engine) into line with the use of UDM, with multiple
> (perhaps related) measure groups, referenced dimension relationships,
> many-to-many dimension relationships, role-playing dimensions, yada, yada.
>
> In the above context, what book is especially good at addressing DW
> modelling for downstream use in the UDM? I was disappointed to note that
> "The Microsoft DW Toolkit" by Kimball Group did not address this. Who does?
>
> Daniel Upton

Daniel,

here you can find a little part of what you are looking for:
http://www.sqlbi.eu/manytomany.aspx
It is a long paper on many-to-many dimension relationships.
If you find it interesting, please write me (marco.russo -at-
sqlbi.eu) so that I can give you more information about what you need.

Marco Russo
http://www.sqlbi.eu
http://sqlblog.com/blogs/marco_russo