I have used Marco's document and actually got some help from Marco and have
successfully implemented a many-to-many data mart.

It works awesome. The ETL was a bit of a challenge. I had often wondered
if it would have been easier to use the "direct connect" method SSAS offers
instead of the typical data mart schema.

Our mart is sort of a medical type business need. We have clients who have
many assessments who have many disabilities who have many pieces of
supporting evidences. So we had many to many to many to many. Is that too
many's?

BTW - I really appreciate folks like Marco and people at the Kimball group
who actually will reply to cry's for help. I know especially the Kimball
group sells their skills and offers training - so for them to provide some
"free" help is extremely appreciated in our dark hours of development.

"Marco Russo" <marco.russo@loader.it> wrote in message
news:1190300398.767680.202810@o80g2000hse.googlegr oups.com...
>
> 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
>