Home Forums Data Warehousing Analysis Services Cube changes not showing in the Database in the SSAS server instance RE: Cube changes not showing in the Database in the SSAS server instance

  • April 8, 2015 at 5:00 pm

    #1789738

    alkassimdiallo (4/7/2015)

    Hi - I am new to this forum and trying to figur out how to deploy and process a cube from Visual Studio 2010 v10.sp1 to SSAS v11.0 with sql server 2012.

    1.I am generating the xmla file using the deployment wizard in VS

    2. then have to opend the xmla script in SMS to add my password and remove the Roles section<Roles> </Roles> as I do not have permissions to depploy and process from VS. I have tried that and each time it dropped the roles and the database is dropped

    3. Then After I ran the xmla script I got the error below

    <Error ErrorCode="3239575561" Description="The Role role referenced by the DataSourcePermission permission does not exist in the DataSourcePermission database." Source="Microsoft SQL Server 2012 Analysis Services" HelpFile="" />

    </Messages>

    4. I am just pulling from a sql server datasource if that helps. Any idea on what is going on? and what solution will get this resolved? Thanks

    Thanks,

    Al

    This is what I found when trying the same thing:

    In the generated xmla file, there are other references to your roles as well. See the <CubePermissions> and <DatabasePermissions> sections. My guess is that the script fails because of the fact that you've removed the role, but not the other references to the role.

    Note: I am using SSAS 2014, and not sure whether it may be different than 2012.

    I'd also advise against editing the xmla file manually. It is very easy to make a mistake that could cause a lot of headaches. The deployment wizard gives you the option (at least my version does) to retain or replace roles/permissions.