KB215521: Derived element on an attribute from an object prompt is deleted when deleting the unused managed objects at the project level, in MicroStrategy Analytics Enterprise 9.4.1

SUMMARY:
This document describes an issue with the "delete unused managed objects" setting, available in Strategy Developer. This setting deletes any derived element created off an attribute selected from an object prompt, causing an execution error in the report that contains the derived element. This issue has been addressed in Strategy 9.4.1 HF7.
 
SYMPTOM:
After deleting unused managed objects for a project, a report that contains a derived element  no longer runs correctly returning the following error, in Strategy Web 9.x:

The requested object with ID 'xxx' and Type 48 (Consolidation Element) does not exist in the object context. Error un Process method of Component: ResolutionServer

 
STEPS TO REPRODUCE:
These are the steps to reproduce in Strategy Tutorial:

1. Create an object prompt on Quarter attribute.
2. Create a report with the prompt created in the previous step.
3. Run the report and select Quarter when prompted.
4. Create a derived element on Quarter (this option is only available in Strategy Web, after executing the report).
5. Save the report as prompted.
6. Delete unused managed objects, which can be found in Strategy Developer, under Administration menu > Projects.
7. Run the report created in Step 5.

 
CAUSE:
This is a known issue in Strategy Developer/Web 9.x. The derived element created off the object prompt selected attribute is a managed object, which is considered as a weak reference to the report. When deleting unused managed objects the derived element is deleted, hence the error.
 
ACTION:
This issue has been addressed in Strategy Analytics Enterprise 9.4.1 Hotfix 7. Upgrade to that version to take advantage of this fix.
 
The Internal Reference Number for the issue discussed in this Knowledge Base Article is 978837.