Applying security on particular data

hi all,
i have scenario have bound users accessing cube based on department belong to.
a particular use should able see own department's data when uses organization dimension.

my far though solution create multiple db views each filtered department wise, , have many cubes have department, @ time of deployment each cube connected appropriate organization view, use see organization data.

is there better approach in someone's mind, wondering if possible apply role security on data , 1 step more applying on dimension itself.

thanks.

yes can restrict access elements of dimension.

 

this can done via roles.

 

hope help.

 

pierre

SQL Server  >  SQL Server Analysis Services