You can also upgrade Analysis Center in a distributed environment.
To upgrade in a distributed environment:
If you installed the Analysis Center Data Extension, use the Modify option of the Analysis Center setup program to uninstall the Data Extension from the SQL Server Reporting Services computer.
If you are upgrading the SQL Server, upgrade the SQL Server on the following components of Analysis Center after installing Analysis Center:
The SQL Server instance containing the Data Warehouse and Configuration database (required).
The SQL Server Analysis Services instance containing the AC_OLAP database (required).
The SQL Server Reporting Services instance containing the Data Extension component (required).
The SQL Server instances containing the Data Marts (optional upgrade).
Run the Analysis Center setup program to upgrade the Data Warehouse, Web Service, and Console components on each of the SQL Server instances running these components.
Install the Data Extension using the Modify option of the Analysis Center setup program.
Start the Analysis Center Console.