Portfolio Analyzer Views Migration tool

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.


Topic Last Modified: 2016-11-14

The Portfolio Analyzer Views Migration tool is a utility in the Project Server 2007 Project Resource Kit (PRK). It enables administrators to bulk edit the Microsoft SQL Server Analysis Services settings in Data Analysis views. This is particularly useful when a Microsoft Office Project Server 2003 database has been migrated to Microsoft Office Project Server 2007 and the computer on which SQL Server Analysis Services is installed has changed. The benefit of using this tool is that administrators avoid having to manually edit the values for each view individually.

Click to download (http://www.microsoft.com/downloads/details.aspx?FamilyId=A33D253C-6424-48E4-B87E-0861D1977BB7\&displaylang=en) the Project Server 2007 PRK from the Microsoft Download Center.


The Portfolio Analyzer Views Migration tool has the following requirements for usage:

  • Microsoft Windows XP, Windows Vista, or Windows Server 2003.

  • Microsoft .NET Framework 2.x or 3.x.

Migrate Portfolio Analyzer views

  1. Run PAViewsMigration.exe to start the Portfolio Analyzer Views Migration tool.

  2. On the Project Server URL page, specify the Office Project Server 2007 instance where the Data Analysis views exist. In the Project Server URL box, type the URL of your Project Server instance. Click Next.

    Port Analyzer Views Migration tool

  3. On the Select an Authentication Mode page, select the authentication mode that you use to connect to Project Server. Your options are:

    Port Analyzer - select an authentication mode

    • Use Windows Account information.

    • Use forms authentication account. You will also need to enter your user name and password.

    Click Next.

  4. On the Select Views page, specify the Data Analysis views that you are going to bulk edit. All available views are shown in the Available Views list.

    Port Analyzer for views migration dialog box

    Use the buttons as follows to put views in the Migrate Views list:

    • Click Add All to move all available views to the Migrate Views list.

    • Click Add to move individual views to the Migrate Views list.

    • Click Remove to move individual views from the Migrate Views list to the Available Views list.

    • Click Remove All to move all views from the Migrate Views list to the Available Views list.

    Click Next.

  5. On the Analysis Server page, specify the SQL Server Analysis Server and the Analysis Server database that the views will use.

    Portfolio Analyzer - Analysis Server search

    • In the Analysis Server box, type the name of the Analysis Server.

    • In the Analysis Server Database box, select the Analysis Server database from the drop-down list.

    Click Next. The tool goes through each view and sets the view to reference the SQL Server Analysis Services server that you specified.

Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Downloadable content for Project Server 2007.

See Also


Managing the Cube Building Service in Project Server 2007
Configure Office Project Server 2007 to use the Cube Building Service