KB7455: ’ORA-00942: table or view does not exist. Error Code -2147467259’ error message appears when browsing through an attribute in MicroStrategy Developer 9.4.x-10.x against Oracle

SYMPTOM:
When they browse through an attribute using the Data Explorer in Strategy Developer 9.4.x-10.x, users see the following error message:

'ORA-00942: table or view does not exist. Error Code -2147467259.'
 
 
CAUSE:
This issue occurs because the attribute being used is defined based on a table that does not exist in the warehouse.
 
ACTION:
To resolve this issue, the administrator must follow the steps below:

1. Run the Warehouse Catalog from the Schema menu in Strategy Developer.
2. Select 'Read the Warehouse Catalog' from the Actions menu.
3. Edit the attribute. Select its ID form and click on 'Modify'.
4. Un-check the box for the table that is no longer available in the Warehouse.
5. Save and Close.
6. Run 'Update Schema' from the Schema menu.