cd100808_tabase_per_Cube___Benny_Austin__0
[One Database, many Cubes] Depending on the nature of change, sometimes all cubes in the SSAS database may have to be reprocessed after a deployment. Structural changes to dimensions especially the shared ones will require all the cubes in the database to be reprocessed after deployment. SSIS packages are usually required to mimic SSAS processing schedule to process specific cubes within the database taking into account the sequence of processing dimensions, measure groups, partitions and indexes. Care should be taken not to process the shared dimensions in full process mode as it could take all associated cubes offline. [One Database per Cube] Because there is only one cube in the database there is no dependency on shared dimensions. [0] 
Processing Options
R e u s a b i l i t y o f S h a r e d D i m e n s i o n s
S e c u r i t y
D e v e l o p m e n t a n d M a i n t e n a n c e
D e p l o y m e n t
P r o c e s s i n g O p t i o n s
D a s h b o a r d s
SSAS: One Database, many Cubes Vs. One Database per Cube | Benny Austin
0