none
SSAS Roles RRS feed

  • Question

  • Hello,

    If I deploy the SSAS project trough XMLA then please let me know the roles will exists or it will be get delete.

    Sanjay

    Monday, July 8, 2013 3:02 AM

Answers

  • Hello,

    If I deploy the SSAS project trough XMLA then please let me know the roles will exists or it will be get delete.

    Sanjay

    Hi Sanjay,

    I recommend you use Analysis Services Deployment Wizard to generate the XMLA script. We can select an option to deploy roles and retain members. Please refer to the following options when use deployment wizard to deploy SSAS cube:

    • Deploy roles and members. Any existing roles and members will be replaced.
    • Deploy roles and retain members. Roles will be deployed along with their members for new roles. Members for existing roles will be retained.
    • Retain roles and members. The roles and members will not be deployed.

    For more information about SSAS deployment methods, please see:
    http://technet.microsoft.com/en-in/library/ms175446(v=sql.105).aspx

    Best Regards,


    Elvis Long
    TechNet Community Support

    Tuesday, July 9, 2013 7:29 AM
    Moderator

All replies

  • The roles will be deployed using XMLA, however you need to update the roles on the target server after deployment.

    ids generated for local user of the server and security groups are machine specific and this will not be same for the target machine.

    Check this blog - http://dataonwheels.wordpress.com/tag/xmla/

    and search for changes post-deployment on roles.

    Also, if you just have AD roles, then you can write a powershell script for end to end deployment

    Cheers,

    MM

    Monday, July 8, 2013 5:27 AM
  • Hello,

    If I deploy the SSAS project trough XMLA then please let me know the roles will exists or it will be get delete.

    Sanjay

    Hi Sanjay,

    I recommend you use Analysis Services Deployment Wizard to generate the XMLA script. We can select an option to deploy roles and retain members. Please refer to the following options when use deployment wizard to deploy SSAS cube:

    • Deploy roles and members. Any existing roles and members will be replaced.
    • Deploy roles and retain members. Roles will be deployed along with their members for new roles. Members for existing roles will be retained.
    • Retain roles and members. The roles and members will not be deployed.

    For more information about SSAS deployment methods, please see:
    http://technet.microsoft.com/en-in/library/ms175446(v=sql.105).aspx

    Best Regards,


    Elvis Long
    TechNet Community Support

    Tuesday, July 9, 2013 7:29 AM
    Moderator