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. Is anyone aware of and/or has experience with an Add-in appication for MS Project that would accomplish provide this functionality?