KB44660: "Analytical Engine calculation error: calculation event evaluation failed" error message when using Derived Metrics in MicroStrategy 9.3.x and higher

SUMMARY:
The error message "Analytical Engine calculation error: calculation event evaluation failed" is an indication that the Evaluation Order of nested derived metrics failed to generate a result. By default, Strategy does not assign a specific evaluation order to derived metrics. In scenarios where derived metrics require to be resolved in a specific order, such as nested derived metrics, developers must choose a non-default evaluation order.
  
SYMPTOM:
When executing a report with multiple derived metrics, or nested derived metrics, the following error message is generated:
 

Analytical Engine calculation error: calculation event evaluation failed

Sum((
/)) {Category} 

1. Open the toolbar "Data"
2. Click on "Report Data Options"
3. Expand "Calculations"
4. Select "Evaluation Order"
5. Uncheck "Use Defauly Evaluation Order"
6. Reorder the derived metrics so that the parent derived metric is the last one to be evaluated. This can be changed by clicking the box next to the metric, then selecting the number rank that you wish to order the calculations.

 
 
LEARN MORE:
KB31910: What are the Data Set and View evaluation orders in the Report Data Options Evaluation Order panel in MicroStrategy Developer?
 
KB42679: Derived elements do not show up in Evaluation order of a document or dashboard in Microstrategy Desktop 9.x