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.