none
Best practices to add new cubes in PWA Cubes DB and Security concern ? RRS feed

  • Question

  • Hi,

    I search and don't find nothing on this subject.

    I wanna know if a best practices exist for adding new cubes for PWA ?

    Also I wanna know what is the best practices to make the security to let some person to add new cubes and to modify existing cubes ?

    We try to add a new roles on the cube DB but the rights seems to be flushed by the process that run the cube creation.

    Thank you.

    Stephen C.

     

    Monday, June 8, 2015 2:37 PM

Answers

  • Hi Stephen,

    The Project Server OLAP cubes (assuming this is what you are refering to) are 14: 11 standard cubes and 3 virtual cubes. You cannot add a new cube, just updating existing ones by adding dimensions, measures, MDX formula.

    See reference: https://technet.microsoft.com/en-us/library/ff465339.aspx

    Then the security for accessing OLAP cube is managed through a "View OLAP Data" permission. You cannot set custom permissions for OLAP data access.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    • Marked as answer by SittButt Monday, June 8, 2015 2:55 PM
    Monday, June 8, 2015 2:48 PM
    Moderator

All replies

  • Hi Stephen,

    The Project Server OLAP cubes (assuming this is what you are refering to) are 14: 11 standard cubes and 3 virtual cubes. You cannot add a new cube, just updating existing ones by adding dimensions, measures, MDX formula.

    See reference: https://technet.microsoft.com/en-us/library/ff465339.aspx

    Then the security for accessing OLAP cube is managed through a "View OLAP Data" permission. You cannot set custom permissions for OLAP data access.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    • Marked as answer by SittButt Monday, June 8, 2015 2:55 PM
    Monday, June 8, 2015 2:48 PM
    Moderator
  • How did you update the existing ones ?

    With VS2012+BI addons ?

    With the "Manage Olap database" panel ?

    Tuesday, June 9, 2015 11:47 AM
  • It depends which Project Server version do you have.

    Anyway it will not be development with VS, just configuration. See this article.

    • With Project Server 2010, go to PWA, OLAP configuration.
    • With Project Server 2013, it is from the central administration.

    Note that there is no OLAP DB with PRoject Online.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    Tuesday, June 9, 2015 12:33 PM
    Moderator