KB45881: "Cannot delete 'xxx' because other objects depend on it. Do you want to search the dependent objects?" appears when deleting source tables from MicroStrategy Architect 9.x.

 

Cannot delete 'LU_Gender' because other objects depend on it. Do you want to search the dependent objects?

CAUSE:
This works in this manner to allow for quicker deletion of secondary tables. If a table is not the primary lookup table (bold) of an attribute or directly used by another type of object (relationship filter, transformation). Then the objects that do use it can easily just have it unchecked as a source table. This is something the product can do automatically without requiring the end users to remove the table as a source table individually from every attribute and fact that uses it. This is done simply to allow for quicker architecting of an environment and is why the warning message is displayed.
The reason this can't be done for attributes that use the table as a lookup table is that each attribute must have one single lookup table (bold). If a lookup table was removed the Strategy product would have no means to know which of the other available source tables to pick as the new lookup table. Hence the error seen when those sorts of attributes are involved.
Below is an attribute showing which table is the primary lookup table. If this was the only attribute in the project then the LU_Customer table could be deleted while the LU_Gender table would not be. This is indicated by the LU_Gender table being bold.