6.4 Upgrading Analysis Center

If you want to upgrade the SQL Servers hosting Analysis Center components, you must first upgrade Analysis Center and then upgrade the SQL Servers that have the following components installed:

  • The SQL Server instance containing Data Warehouse and Configuration database.

  • The SQL Server Analysis Services instance containing AC_OLAP database.

  • The SQL Server Reporting Services instance containing Data Extension component.

  • (Optional) The SQL Server instances containing Data Marts.

NOTE:All SQL Servers hosting Configuration database, AC_OLAP database, and Data Extension components must have the same version.

For more information about upgrading the SQL Server version, see the Microsoft SQL Server documentation.

To upgrade Analysis Center:

  1. Log into the computer where you want to upgrade Analysis Center by using an account that hasSQL Server system administrator privileges.

  2. Run the Analysis Center setup program and follow the on-screen prompts.

  3. (Conditional) If you run the installer on a Windows Server 2003 computer that has Analysis Center 2.9 Data Extension and Security Update for Windows Server 2003 (KB2918614) installed, you must uninstall this security update for the installer to proceed. For more information about this security update, see the Microsoft Support website.

  4. (Conditional) If you run the installer on a SQL Server 2005 computer that has Analysis Center 2.9 Data Extension installed, Reporting Center Data Extension does not install on this computer. You must install Reporting Center Data Extension on SQL Server 2008 or later computer.

  5. (Conditional) If Data Warehouse is installed on the computer, you are prompted to select the reports to migrate from Analysis Center Console to Reporting Console. To migrate the reports, select the reports and click Migrate. If you do not want to migrate the reports, click Skip.

    You can also migrate reports after upgrading to Analysis Center 3.0 or later. To migrate the reports using the Report Migration utility after the upgrade, see the Section 8.4, Migrating the Reports to Reporting Center.

    IMPORTANT:Migrating the reports during the upgrade takes a considerable amount of time. NetIQ recommends you to skip the migration during the upgrade and use the Report Migration utility from the Admin Console to migrate the reports after the upgrade.