cd100808_tabase_per_Cube___Benny_Austin__0
[One Database, many Cubes] Requires one SSAS project in BIDS. The Shared dimensions can be defined once and linked to associated measures groups. Code maintenance is in one place. [One Database per Cube] Requires one SSAS project in BIDS for each database. Shared dimensions have to be created once on each project. If sufficient care is not taken during development, it could break the conformity of dimensions. Maintaining consistent attributes and names, hierarchy and levels, key and name columns, sort order could become a development and maintenance challenge. [0] 
Development and Maintenance
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