KB43370: How to remove an MDX database instance, in MicroStrategy 2021 and above when the "Remove" button is grayed out.

The steps below detail how to properly remove an MDX Database Instance from a project source in Strategy Strategy 2021 and above when the 'Remove' button is grayed out in the schema maintenance window. If the database instance has any cubes in it, please refer to KB42467: How to remove an MDX database instance, in MicroStrategy Developer 9.x. to delete the cube first and then remove the MDX database instance.
 

1. Right-click on the project and select Project Configuration > Database Instance > MDX Data Warehouses. If the MDX Database Instance displays in bold, click on "Schema Maintenance...",and see if the"Remove" button is grayed out.
2. If the Remove button is grayed out, there are some hidden dependents for that instance that still has to be removed. So in order to find out the dependents run the following query against the metadata:
   

   
   SELECT * FROM DSSMDOBJDEPN where depn_objid = 'database instance ID'

   
   
3. From the result set, with the object_id associated with the depn_objid, search for the objects in Developer. Check the following options: 'Display hidden objects', 'Display Managed objects' and ' Display managed objects only'.     
4. Click on `OK` and `Find now`. The list of objects managed by the system should now show up. Right click on them and select `delete` to remove them.
5. Now you can go and Right-click on the project and select Project Configuration > Database Instance > MDX Data Warehouses.Click on "Schema Maintenance...", highlight it and click on "Remove".