KB440743: Dashboard returns extra rows for Derived Attribute or Derived Element

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

• Incorrect data is returned for the Derived Attribute or Derived Element placed in the grid.
• Incorrect CSI is generated for the Derived Attribute or Derived Element .
• Running a copy of the VI Dashboard/Dossier shows correct data.

Note that the Job Title for Employee Bob Builder includes Animator and 3D Animator when only Animator is expected.

This is a known defect appearing in Strategy 10.4 - 10.9.
It is caused due to incorrect handling of Big Relation generation for Derived Attributes and Derived Elements.

This issue has been resolved in the Strategy 10.11 Release.
This issue has been fixed in Strategy 10.11. Please upgrade to Strategy 10.11 or above to pick up the fix.
If you are upgrading to Strategy 10.9 / 10.10 / 10.11:
To pick up the fix, enable the Feature Flag "Defect fixes that may impact Data, SQL, MDX, CSI" within the Web Preferences -> Project Defaults.
For more details on enabling Feature Flags, please refer this page .
Starting Strategy 11.0, this Feature Flag is removed and replaced with project level setting called "Data Engine Version".
If you are upgrading to Strategy 11.0 or above:
To pick up the fix, enable project level setting "Data Engine Version" to 11.
This property can only be enabled through Workstation. For more details on enabling the setting, refer to Change Data Engine Version.