Report Portal

Tips: Processing Large Dimensions

With the good weather subsiding here in Seattle for a few days I'm feeling motivated to post something today.
 
Recently there was a post on LinkedIn regarding large dimensional updates (millions of members) in SSAS. The release of Analysis Services 2005 greatly increased the ability to process large dimension compared to AS 2000. Dimensional updates that weren't possible in 2000 are now easily done in 2005.
 
I've dealt with somewhat large dimensions (five to twenty million members) so I thought I'd share some tips that have allowed me to perform daily updates in an acceptable manner.

Read more...

 

Tags: process, tip

 

2007-2015 VidasSoft Systems Inc.