SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


OLAP security Roles


OLAP security Roles

Author
Message
aslorenzo
aslorenzo
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 108
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,
robert.gerald.taylor
robert.gerald.taylor
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1795 Visits: 1489
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
aslorenzo
aslorenzo
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 108
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 ?
robert.gerald.taylor
robert.gerald.taylor
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1795 Visits: 1489
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
aslorenzo
aslorenzo
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 108
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.
richykong
richykong
SSC-Enthusiastic
SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)

Group: General Forum Members
Points: 192 Visits: 621
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search