KB484803: Fix the document execution error for complex Derived Metrics with nested Derived Metrics defined on Derived Attributes

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.
Description
When there are complex Derived Metrics with multiple layers and the nested derived metrics defined on Derived Attributes, the document execute failed starting from Strategy 2019 with Data Engine Version set to 2019.
Steps to reproduce
This procedure is using Strategy Tutorial WH that is shipped with Strategy products.

1. Login to Strategy Web, go to Add External Data -> Databases -> Pick Tables and pick the following table and columns

1. Click Finish to Import as an In-memory Dataset and save as MTDI01

1. Go to Add External Data -> Databases -> Pick Tables and pick the following table and columns

1. Click Finish to Import as an In-memory Dataset and save as MTDI02
2. Create dossier based on MTDI01 and add MTDI02 as another dataset

1. Create Derived Attributes and Derived Metrics in the first dataset as below:

Derived Attribute Today: CurrentDate()
Derived Attribute Week: Week([Today@ID])
Derived Attribute Year: Year([Today@ID])
Derived Attribute YearWeek: Case((Week@ID<10), Concat(Year@ID, 0, Week@ID), Concat(Year@ID, Week@ID))
Derived Metric DM1: Max(YearWeek@ID){~+}
Derived Metric DM2: ToNumber(DM01)
Derived Metric DM3: Max(DM02){~+}
Derived Metric DM4: Case((DM02=52), 1, (DM02+1))
Derived Metric DM5: Concat(" WK ", SubStr(DM03, 5, 2))
Derived Metric DM6: Concat(" WK ", SubStr(DM04, 1, 2))

1. Add into template: DM5, DM6

1. The dossier execution failed with error: 

Cause:
This is a regression issue starting from Strategy 2019 with “Data Engine Version” set to 2019.
Solution:
This issue has been addressed in Strategy 2021.
To pick up the fix, upgrade to Strategy 2021 or above and enable project level setting "Data Engine Version" to 2020 or above. For more details on enabling the setting, refer to Change Data Engine Version.
After the fix, the document can execute successfully and return the same data as Strategy 10.4.

Strategy internal reference number for this technical note is DE182675.