cd100808_tabase_per_Cube___Benny_Austin__0
[One Database, many Cubes] Having all cubes in one database facilitates reuse of common dimensions like Client, Organisation Hierarchy, and Date/Time across all related cubes. The attributes and hierarchies of shared dimensions are consistent throughout all cubes in the database. [One Database per Cube] Having one cube per database gives the flexibility to customize dimension attributes and hierarchies that is relevant to specific audience. For e.g. attributes that are not relevant to a target audience can be removed. [0] 
Reusability of Shared Dimensions
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