SEO

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

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

Thank you, Marco. I've downloaded your PDF and look forward to learning m2m.

"Marco Russo" wrote:

>
> 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
>
>

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
>

I appreciate the feedback, Joe. I know what you mean about "dark hours", and
I am sometimes in need of -- often humbled by, and occasionally have my
bacon-saved, by -- the help available in the MSDN community. Although I'm
usually interacting on the "MDX and Analysis Services" thread, I'm glad to
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.
Cheers, Joe!

Daniel

"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.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
> >
>