cd100808_tabase_per_Cube___Benny_Austin__0
[One Database, many Cubes] Role based security model can be defined once for the database and has to be re-visited only when a new cube or dimension (that requires Dimension Data Access) is created. Dimension Data Access defined on shared database dimensions by default is inherited by all cubes in the database. This provides a consistent security model. If the dimension data access has to be customized for a specific cube in the database then the default access can be overridden by defining data access on cube dimension. [One Database per Cube] Role based security model has to be defined for every database. Dimension Data Access defined on shared database dimensions is usually sufficient unless dimension security has to be defined on a role playing dimension. [0] 
Security
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