Steps to uninstall Analysis Cubes

The Analysis Cubes installer is not supported with SQL Server 2019 on Dynamics GP.

When testing or customizing Analysis Cubes for GP, you may find that you are unable to completely uninstall the product. If you uninstall Analysis Cubes from the Control Panel, it does not remove the SQL components. To completely remove Analysis Cubes, you will need to manually delete all of the Analysis Cubes objects in SQL Management Studio via the following steps:

1. Connect to the SQL Database Engine, expand Databases and then delete the data warehouse:

2. Expand SQL Server Agent and under Jobs, delete the job:

3. Connect to SQL Server Integration Services, then expand Stored Packages, MSDB and then DynamicsGPWarehouse:

4. Delete each package under the DynamicsGPWarehouse folder individually, and then delete the DynamicsGPWarehouse folder itself.

5. Connect to SQL Server Analysis Services, expand Databases, and then delete the Dynamics GP Analysis Cubes database:

If you would like to reinstall, run the installation wizard again. If the cube objects have been manually uninstalled with the above steps, it will run through exactly as it did the first time. If there are cube objects currently installed, the following three options will appear when you get to the Analysis Services Cube Setup window of the install.

• Use  existing Analysis Services database and repopulate data for the cubes
• Replace existing Analysis Services database and create a new database using the same name
• Create a new Analysis Services database using the following name