Performance tuning information on Many-to-many dimension

On Dec 22, 1:46 am, "Ohjoo Kwon" wrote:
> I found a white paper below.
>
> http://www.microsoft.com/downloads/details.aspx?FamilyID=3494E712-C90....
>
> Any more information will be appreciated.
>
> Ohjoo
>
> "Ohjoo Kwon" wrote in message
>
>
>
>
>
> > Is there any performance tuning information on Many-to-many dimension?
>
> > Ohjoo- Hide quoted text -
>
> - Show quoted text -

That is a very good paper about performance with M2M.
If you want more information about data modeling using M2M, take a
look at "The many-to-many revolution" paper here: http://www.sqlbi.com/manytomany.aspx

Marco Russo
http://www.sqlbi.com
http://sqlblog.com/blogs/marco_russo
 >> Stay informed about: Performance tuning information on Many-to-many dimension 

Marco,

Do you have any metrics comparing regular vs. M2M dimensions, that is,
the performance of say a cube with 5 dimensions, 4 of them regular,
and 1 of them M2M, to that of the performance of a cube with all 5
being regular? Looking at both query time and cube processing time?
Even something anecdotal would be appreciated. I was wondering if we
were the only ones seeing a bit of a perf. degradation when going the
M2M route (even though project requirements can trump the concern of
this).

Thanks,
-exologic


::: Pain with Essbase? Use CubePort, The BI Porting App :::
::: Go from Essbase to Microsoft Analysis Services :::
::: web: exologic.com/products.htm :::
 >> Stay informed about: Performance tuning information on Many-to-many dimension