Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

SSAS - Error THE ‘ROLE’ WITH ‘ID’ = {ID} DOESN’T EXIST IN THE COLLECTION.

Discussion in 'Business Intelligence' started by Peter Schmitz, Nov 14, 2017.

  1. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    Today I was working on a new cube project. Basically we will be adding existing as well as new objects to a new cube. This will ensure the users will not be overwhelmed with all the objects existing in the existing cubes, but rather just see the subset they are interested in (and taking these from several other cubes, hence not being able to just create a perspective).

    Rather than re-doing all the work involved in defining dimensions, I imported the existing ones by right-clicking on the project, and selecting "Add" -> "Existing Item":

    upload_2017-11-14_13-56-44.png

    Unfortunately, when I then attempted to build the cube, I was greeted with the error message:

    Apparently one of the objects I just added to the project contained some security settings. To resolve this, I right-clicked the dimensions in the project, and used the "View Code" option.

    In the code, you should look for "Permisisons". In my case, this revealed the following code:

    After removing that entire block of code, i was able to build my project again.

Share This Page