Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

M2M Dimension Optimisation Techniques Paper

leave a comment »

Another new paper from the SQLCat team, this time on techniques that can be used to optimise cubes that use many-to-many relationships:
 
I’ve only skimmed through it so far, but I thought I’d mention two other tricks to try with m2m dimensions. One is breaking up large dimensions if you don’t ever need to see them, which I blogged about in detail here: http://cwebbbi.spaces.live.com/Blog/cns!7B84B0F2C239489A!777.entry, and which can be very powerful. The other is introducing other dimensions to the intermediate measure group: for example, imagine you have a measure group showing the relationship between Products and the Components that make them up, you could try adding the Time dimension to that measure group; even though it will increase the size of the measure group because you are repeating the Product/Component combinations for each Time period, if all of your queries are sliced by a Time period and you know that the majority of your Products were only sold for a short space of time then it can be beneficial, although if neither of these conditions is true then doing this can have a negative impact on performance too.

Written by Chris Webb

December 21, 2007 at 11:43 pm

Posted in Analysis Services

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,113 other followers

%d bloggers like this: