KB442371: "Unspecified error" is displayed for a dossier with at least two dataset with attributes linked, derived attribute and conditional metric

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

Symptom:

When using multiple dataset, linked by liking attributes, and created derived attributes or conditional metrics, dossiers fail with error messages like below.

In-Memory query execution failed against Intelligent Cube due to duplicate rows found in one of the fact tables. Please review the Query Details to identify and remove the duplicate rows and try again

This issue is specific to Strategy 11.0 and lower.

Cause:

This is an known issue in Strategy 11.0 and lower.
This issue was caused when we fix KB442281: Starting 10.4.8 and 10.11, a dashboard with multiple datasets using nested aggregated metric together with element group shows empty results
Engine logic has been optimized to fix this issue.

Action:

The defect has been addressed in Strategy 2019.
Strategy internal reference numbers is KB442371 and DE123410.