SYMPTOM:
When a user tries to delete a Freeform SQL report in Strategy Developer, a dependency message appears stating that there is a dependent object which is a shortcut to an attribute. The dependency search on the Freeform SQL report shows that the shortcut is located at System Objects\Schema Folder, i.e. in the Invisible Objects. Refer to the following Strategy Knowledge Base technical note for more information:
KB20229 (KB5700-8X-3405): How to display invisible objects in Strategy Developer
CAUSE:
Whenever a Freeform SQL report is created, a shortcut is placed in that schema folder by default.
ACTION:
If the user has to delete the Freeform SQL report in Strategy Developer, it is necessary to delete the attribute the dependency is pointing to. Once the attribute is deleted, the user will be able to delete the report.
