KB484914: Fix the data issue when the derived metric in dossier visualization is using base metric from different dataset with Data Engine Version 2021

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.
Description
The Derived Metric returns different value when choosing different Data Sources if the Derived Metric based on Base Metrics which are from different datasets and the Base Metrics exist in multiple datasets. The fix is made with Data Engine Version 2021.
Steps to Reproduce
This procedure is using Strategy Tutorial WH that is shipped with Strategy products.

1. Login Strategy Developer, create Intelligent Cube C01 with: Attribute Quarter, Month, Country, Region and Metric Cost, Revenue
2. Create Intelligent Cube C02 with: Attribute Year, Quarter, Country and Metric Cost, Revenue
3. Login Strategy Web, create Subset Report SubR01 based on Intelligent Cube C01
4. Create Derived Smart Metric DM with expression: Sum(Cost){~+}

1. Add into template: Attribute Quarter, Region and Metric DM
2. Create Subset Report SubR02 based on Intelligent Cube C02, add into template: Attribute Country, Year, Quarter and Metric Cost, Revenue
3. Create Normal Report R01 with: Attribute Country, Region, Quarter, Month, and Metric Cost, Revenue
4. Create Dossier with SubR01, SubR02 and R01 as datasets, create Derived Metric DM/Rev in dataset SubR02 with expression: DM/Revenue
5. Add into Visualization: DM/Rev, switch the Data Source of Visualization between SubR01 and SubR02

1. Check the metric value, the data is different when choosing different Data Source

1. View Query Details for Visualization with Data Source SubR01

************   Individual Step Start   ************
Number of Rows Returned: 1
Time Spent: 0.003 sec(s)
Query Execution Start Time: 3/18/2021 3:34:24 PM
Query Execution End Time: 3/18/2021 3:34:24 PM
select  sum([Revenue]),
            sum([Cost])
from    SubR02=C02,Year,Quarter,Country,Cost
************   Individual Step End     ************
 

1. View Query Details for Visualization with Data Source SubR02

************   Individual Step Start   ************
Number of Rows Returned: 1
Time Spent: 0.000 sec(s)
Query Execution Start Time: 3/18/2021 3:34:24 PM
Query Execution End Time: 3/18/2021 3:34:24 PM
select  sum([Cost])
from    SubR01=C01,Quarter,Region,DM
to            Ex7_tempcube0
************   Individual Step End     ************
************   Individual Step Start   ************
Number of Rows Returned: 1
Time Spent: 0.002 sec(s)
Query Execution Start Time: 3/18/2021 3:34:24 PM
Query Execution End Time: 3/18/2021 3:34:24 PM
select    sum([Revenue])
from       SubR02=C02,Year,Quarter,Country,Cost
to            Ex7_tempcube1
************   Individual Step End     ************
************   Individual Step Start   ************
Number of Rows Returned: 1
Time Spent: 0.001 sec(s)
Query Execution Start Time: 3/18/2021 3:34:24 PM
Query Execution End Time: 3/18/2021 3:34:24 PM
select    *             
from       Cross Join(
                           Ex7_tempcube0,
                           Ex7_tempcube1
                          )
************   Individual Step End     ************
Cause
This is a known issue in Strategy.
 
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 2021 or above. For more details on enabling the setting, refer to Change Data Engine Version.
After the fix, the Visualizations return same data for different Data Sources.

Check the Query Details, it’s the same for Visualizations with different Data Sources.
************   Individual Step Start   ************
Number of Rows Returned: 1
Time Spent: 0.002 sec(s)
Query Execution Start Time: 3/18/2021 4:11:09 PM
Query Execution End Time: 3/18/2021 4:11:09 PM
select    sum([Cost])
from       SubR01=C01,Quarter,Region,DM
to            Ex0_tempcube0
************   Individual Step End     ************
************   Individual Step Start   ************
Number of Rows Returned: 1
Time Spent: 0.002 sec(s)
Query Execution Start Time: 3/18/2021 4:11:09 PM
Query Execution End Time: 3/18/2021 4:11:09 PM
select    sum([Revenue])
from       SubR02=C02,Year,Quarter,Country,Cost
to            Ex0_tempcube1
************   Individual Step End     ************
************   Individual Step Start   ************
Number of Rows Returned: 1
Time Spent: 0.001 sec(s)
Query Execution Start Time: 3/18/2021 4:11:09 PM
Query Execution End Time: 3/18/2021 4:11:09 PM
select    *             
from       Cross Join(
                           Ex0_tempcube0,
                           Ex0_tempcube1
                          )
************   Individual Step End     ************
Strategy internal reference number for this technical note is DE165055.