OLAP security Roles

  • 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.

    Thanks for you help,

  • 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.

    http://sqldb.wordpress.com/2006/06/23/deploying-an-analysis-services-database-into-the-production-environment/

    HTH,

    Rob

  • Hello, Robert, thanks for your reply.

    I'm using Dynamics AX sp2 and in the menu, (in "Administration" area) there's a tool to modify the OLAP cube structure.

    That tool is embedded in the ERP and permits also to publish the pivot in the ERP menu.

    When done, there's a button to roll-out the changes in the OLAP database.

    Much probably this button runs a XMLA script that deploys the changes in the OLAP server and for this reason then I lose all the security settings in the roles.

    But the thing I would know is: is possible in any way to save the security settings I made in the roles ?

  • Sorry, I'm not an AX guy, so I don't know if there's something in the product that lets you backup your security settings. I was thinking this was your own cube development.

    Rob

  • Hello Robert with AX 4 sp2 you can modify the OLAP cube structure and publish the pivot in the ERP menu, but the pivot security settings are not managed by AX, but using the SQL server Management Console.

    With the Management Console, we created roles and for each role we setup the security.

    Every time we modify the cube structure using AX and with that AX tool we deploy that modifies in the pivot, then each setting done in the roles is lost.

    Considering that we've a lot of pivot and each pivot have several roles, I can tell that is really annoying to rebuild the security each time.

    For this reason i'm looking for a solution, that permits us to avoid to rebuild the security each time.

    Thanks in advance to anyone that can help me.

  • Can you just generate the create role xmla scripts and run them after you deploy changes to the AX cube?

    AX 4.0 doesn't provide much administrative support for SSAS.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply