SYMPTOM:
The following error occurs when trying to delete a table that has no dependents in Strategy Developer 9.4.x-10.x:
The following tables to be deleted still have dependent objects: (Table Name)






CAUSE:
Part of this behavior is working as designed. In the example provided above, a new column was created called DAY_DATE in a new table.
When the table is first brought over the Warehouse Catalog, Strategy matches up the column names and data types with a column object that exists in the metadata. If there is a match, then it checks the mappings on all of the attributes with this column object. If the mapping is set to automatic, then the new table is added as a source table on those attributes.
This creates the dependency that is checked and this is the part that is working as designed.
However, Strategy should be able to see these dependencies when searching in Strategy Developer 9.4.x-10.x. Right now, Strategy Developer 9.4.x-10.x will only show the Lookup table dependencies in the search. This is a known issue in Strategy Developer 9.4.x-10.x.
ACTION:
Strategy will continue to investigate and post updates as soon as they are available.