I am looking for a solution that provides multi-project analysis and reportiing capabilities using Microsoft Project Server 2007 data files, similar to what is available in Primavera. This involves opening multiple projects, up to and including the entire portfolio (currently between 20-30 projects, and 20K to 30K total number of tasks) and performing analysis based in selected critieria, based on changing business needs. For instance, reviewing Mechancial Engineering tasks for all projects, analyzing projects assigned to a specific Project Manager or evaluating the impact of future (i.e. potential work) on the portfolio. Note: Although it would be ideal to achieve this functionality using MS Project, an Add-in appication or even a solution separate from MS Project (i.e. exporting MS Project data to another application) is under consideration as long as we get the functionality that we are looking for. Any ideas or expereiences, good or bad?