Project Server 2010 Install has reference to using Analysis Services OLAP repository in SQL database RRS feed

  • Question

  • I can find no detail in the Project Server 2010 install information about setting up a OLAP repository database in the SQL server databases like we did with Project Server 2007 and SQL server 2008 and AS 2008.   I am working on installing a large Project Server 2010 install and it appears the OLAP repository is being stored in the local file system not in the SQL database.

    May this be a performance issue when the OLAP cubes get big and number of users requesting BI reports increases?  Also in the past this was a issue for users having access to the data.



    Ray McCoppin
    Friday, October 15, 2010 4:07 PM