I appreciate the feedback, Joe. I know what you mean about "dark hours", and
bacon-saved, by -- the help available in the MSDN community. Although I'm
have received the great feedback here. I also am a Kimball " DW Toolkit"
devotee, and it's nice to hear that their group offers help to those in need.
"Joe" wrote:
> 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.googlegroups.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 > >
