Report Model Security Integration with SSAS 2005

Hi,

I have a question here for report model generated on top of SSAS 2005. If security has been defined in SSAS 2005 cube where RoleA only have access to certain dimension, is this security setting integrated with the report model and propogate down to the report builder when used where RoleA users have no access to dimension allowed?

Thanks,

J Lim

Unfortunately you're going to have to duplicate these security settings in the report model layer, too. You'll need to connect to Reporting Services inside Management Studio and edit the model item security on the report model in question from there. Sorry nobody answered your question months ago.sql