Query Project server 2010 cube RRS feed

  • Question

  • Greetings.

    Just a quick question about Project Server 2010.  I know that there is a cube that is processed each night and includes projects and risk data.

    I have heard I can connect to the cube using the Microsoft SQL Server Analysis Services Datasource Type within SSIS.  I need to do this as I need to run a procedure to extract this data to another destination.

    However, I'd like to access the data direct from the database rather than the cube.

    is this possible? and if so, what database is the cube info stored in? 

    Many thanks

    Wednesday, October 17, 2012 10:04 AM


All replies