KB486759: Executing a report from MicroStrategy Developer fails with error "unimplemented feature. Drop table error."

Symptom

When executing a report from Strategy Developer, odbc error shows: "unimplemented feature. Drop table error." 

Cause

Reviewing SQL of the report, the dot between table prefix and table name is missing, which caused the SQL is failed to be executed.

Solution

Follow below steps to resolve the issue:

1. From warehouse catalog, right-click on the table name and select "Table Prefix..."
2. Add a new table prefix with dot. Click OK. Select it from the list of available prefixes and click OK. 
3. Save and close the Warehouse Catalog.
4. Update Schema.
5. Purge report cache and re-run it to verify the SQL of the report is correct.