KB484032: Unspecified error caused by an aggregate from base (AFB) metric defined by Sum(Case(Clause, Max(attr), 0)) in MicroStrategy 2019

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.

Description

In Strategy 2019 with Data Engine Version set to 11, you may experience an unspecified error with the following AFB metric:
Sum(Case(([Customer City]@ID>0), [Max(Days to Ship)], 0)){}
 

Steps to reproduce

The following example uses the Strategy Tutorial attributes and metrics. 

• Create a new dossier.
• Click Existing Objects.
• Expand Customers and double-click on Customer, Customer City, Days to Ship. 
  

• Click Add.
• Add a second dataset with existing objects.
• Expand Geography and double-click Country and Region.
• Click Add. You have two datasets imported.
  

• Create a derived metric with the formula: Max([Days to Ship]@ID){Customer%}
• Name the metric: Max (Days to Ship)
  

• Create a derived metric with the formula: Sum(Case((Region@ID>0),[Max (Days to Ship)],0)){}
• Name the metric: Sum(Case(Max)))
  

• Drag the attribute, Country, and the derived metric, Sum(Case(Max))), to the grid.

If Data Engine Version is set to 11, the dossier will fail with an unspecified error.

Why is this happening?

This is a known defect in Strategy 2019. The features enabled by Data Engine Version 11 expose a problem with the server engine when dealing with AFB metrics. 
 

Solution

To resolve this defect, you should set the Data Engine Version to 11. The project level setting, Data Engine Version, can only be enabled through Strategy Workstation.
You can also upgrade to Strategy 2019 Update 5 and set the Data Engine Version to 11. 

Glossary 

Data Engine Version A setting to minimize the impact of data changes for platform release upgrades
Aggregate from Base (AFB) metric Uses the attributes in a dataset (the base) when dynamic aggregation is triggered
 
Strategy Internal Reference number for this technical note is KB484032 and DE155272.