aslorenzo (11/11/2012)
Hi all, is there a way to make a backup of the OLAP security roles ?Every time we add a new field to an OLAP cube, in the roles all the security settings are lost.
From what I know, the only way to do that, is to make a backup of the OLAP cubes (enabling the security backup), but if I add a new field this is not possible.
How are you rolling out your cube changes?
If you are just making a change in VS and deploying to your server, you shouldn't be losing the roles and their membership. But if you're creating a create database XMLA script from your dev environment, and then running (after changing connections perhaps) the script in your prod environment you will lose your security settings.
HTH,
Rob