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.
Thanks
Ray
Ray McCoppin