SSAS Articles 
Design SSAS Many to many optimization technique #1 (By Erik Veerman)
Design SSAS Many to many optimization technique #1 (By Erik Veerman)
| SSAS Many to many optimization technique #1 (By Erik Veerman) |
| Written by Erik Veerman |
| Friday, 04 May 2007 10:37 |
|
This has been something brewing for a few weeks that I am just getting to writing down… and yes, naming this idea #1 does imply that I have another idea :) so stay tuned. Before diving into the details, the summary is that this approach when applied against the AdventureWorksDW database was able to take the intermediate measure group rowcount down from approx 16,000 to only 19. Wow… because the size of the intermediate measure group has a big impact on performance. Lets call this the “Many to Many Matrix Relationship Optimization” approach for SSAS M:N relationships… I’ve been working on this with Dan Hardan (Msft) on this because of a need to make the Many to Many relationships perform better. As a background, there are many kinds of many to many relationships, but if I can summarize two of the common kinds…
|
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Using AS Data Mining to Add Forecast Values to a Cube
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
