KB484679: Derived metrics with transformation style formula only work in reports and not dossiers

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

Description 

Using a derived metric with a transformation style formula only works in reports, and not in dossiers. 

Steps to reproduce

• In a dossier, right-click the dataset > Create Metric and switch to Formula Editor.
• Wipe out any existing formulas.
• Enter a transformation metric formula (e.g., Rolling 12 Months of Sale = Sum<UseLookupForAttributes=TRUE>([F_SLS_RTL_LCL (TD)]){~+}|[Rolling 12 Months]|
• Switch to Function Editor.
• “Rolling 12 Months” appears in the Transformation field. However, it appears to be a text label vs. the name of a true transformation object. We should see a transformation icon besides it, indicating the object type.
  

• Add the new derived metric to the visualization grid. It shows up blank.
  

Why is this happening?

If you create the derived metric, Sum(Cost) {~} | [Last Month's] |, in a report, it works like a SQL metric, and the correct data (calculated by SQL) is returned. 
However, if you create the same derived metric in a dossier, the transformation part is lost, and it is calculated as without [Last Month's]. This is the same behavior for a derived metric in Analytical Engine and aggregate from base.

Workaround

Create a grid report with a transformation derived metric, and use the report as the dataset of the dossier.