Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

OLAP security Roles Expand / Collapse
Author
Message
Posted Sunday, November 11, 2012 8:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 12, 2012 12:53 PM
Points: 15, Visits: 104
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,
Post #1383441
Posted Sunday, November 11, 2012 2:58 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, November 24, 2014 12:12 PM
Points: 1,219, Visits: 1,263
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
Post #1383469
Posted Monday, November 12, 2012 6:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 12, 2012 12:53 PM
Points: 15, Visits: 104
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 ?

Post #1383651
Posted Monday, November 12, 2012 7:20 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, November 24, 2014 12:12 PM
Points: 1,219, Visits: 1,263
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
Post #1383688
Posted Monday, November 12, 2012 12:23 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 12, 2012 12:53 PM
Points: 15, Visits: 104
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.
Post #1383816
Posted Monday, November 12, 2012 1:05 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 20, 2014 9:30 AM
Points: 132, Visits: 588
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.
Post #1383841
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse