Project Server OLAP role permissions RRS feed

  • Question

  • Hi

    We have recently configured reporting.

    For the OLAP cube, we are providing role permissions directly from SQL Management Studio, but it is getting deleted every day.

    How can we assign role permissions permanently


    Thursday, November 7, 2013 11:44 AM

All replies

  • Ram,

    It seems weird that the permissions are getting deleted everyday. Have you brought this to the attention of your SQL Admin?

    At this point, I would suggest to confirm your configuration steps against this document.

    Prasanna Adavi,PMP,MCTS,MCITP,MCT

    Thursday, November 7, 2013 12:43 PM
  • Ram,

    this is expected behavior, user permission should be assigned via PWA, every time cube is built custom permissions will be removed

    Hrishi Deshpande Senior Consultant

    Thursday, November 7, 2013 8:35 PM
  • What permissions needs to be assigned from PWA. Please clarify.

    Yes, when the cube build the permissions are getting deleted.


    Friday, November 8, 2013 6:52 AM
  • Hi Ram,

    In Project Server 2010, the user should have the following permissions:

    • View Business Intelligence link (to be able to see the the link in the Quick Launch)
    • View OLAP Data (to be able to connect to views that user OLAP Data)

    For your information, as the rigths are given when the OLAP cube is building, you should provide these rights to the users before building the OLAP Cube.

    Best regards


    Friday, November 8, 2013 8:47 AM
  • Hi,

    I have provided the 'View OLAP DATA' permissions and build the cube. Even then I cannot see the user in 'ProjectServerRolePermissions'.

    Please clarify.


    Friday, November 8, 2013 9:55 AM