KB484355: Cross join produced with a derived attribute returning single value

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.
The derived attribute Today is defined with the constant value as shown below. The following two business cases, which use the Today derived attribute fails when the VLDB Property “Cartesian Join Governing" is set to Cancel Execution.
Derived Attribute called "Today" is defined as: CurrentDate()
 

Case 1: Derived attribute "Today" is used in the template 

Description

The following internationalized error appears when the derived attribute Today is used in a dossier visualization or document grid. 
A cartesian join is detected and execution is aborted per "Cartesian Join Governing" setting. Please review the design of the report/visualization. Excerpt of the query: Ex41_tempcube72 cross join Ex41_tempcube73.[Strategy Error Instance: 5A4D695245F81614B03B9CAD5DB8621B]
 

Workaround

Modify the VLDB property ‘Cartesian Join Governing’ on the Dossier Visualization level or Document Grid level to be Execute Cartesian Join. For details on how to modify the VLDB property, ‘Cartesian Join Governing’, please refer to KB484289: How to set VLDB Property "Cartesian Join Governing."

Case 2: Derived attribute "Today" is used in another derived attribute 

Description 

When defining a derived attribute with the derived attribute Today and another attribute or derived attribute, the following internationalized error appears when executing the dossier or document. 
New attribute: (-1*DateDiff([Completed Time]@ID, Today@ID, "mn"))

Workaround

Open the dossier without data or edit the document, and redefine the derived attribute specified in the error message to directly use the constant, instead of the derived attribute:
(-1*DateDiff([Completed Time]@ID, CurrentDate(), "mn"))