Skip to main content
Solved

Unable to clone data in a metric

  • March 27, 2026
  • 4 replies
  • 37 views

Forum|alt.badge.img+1

Hello,

 

I am trying to give users the ability to initialise data from a statistically generated demand plan using Clone data in metrics. I am using the following set-up, and the clone appears to run, but no data is created in the metric and application history shows no values were moved.

  1. Data import set-up:
  2. Access rights for FCT_Demand Forecasting:

     

  3. The entry in application history:

The documentation analyst was helpful but ultimately didn’t give any indication of why this isn’t working. Any insight would be appreciated.

Thanks,William

Best answer by Jake

Hi ​@William Seath, do the original metric (FCT_Demand Forecasting) and test metric have a formula in them with overrides enabled?

The clone feature will only copy user inputs, including overrides of formula results. If your source Volume Type of Statistical Demand is formulaically derived, those values will not be included when cloning data. 

4 replies

Julie Guérin
Employee
Forum|alt.badge.img+8

Hi ​@William Seath,

The most likely explanation for this trace is that there were no values to clone, meaning the metric was blank. Could you confirm whether there were any values for the intersection you attempted to clone?

You could also try cloning a different intersection in a test metric to see if the issue persists.

Thanks!


Forum|alt.badge.img+1
  • Author
  • Apprentice Author
  • March 30, 2026

Hello ​@Julie Guérin,

I can confirm there are values in the intersection I attempted to clone, and that this doesn’t run when I change the configuration to run on all intersections. I get the same behaviour when I create a test metric cloning on the same dimension.
The test metric is dimensioned by Week and Volume Type (the dimension I am trying to clone across), whereas the original metric is dimensioned by Week, SKU, Customer Plan, and Volume Type.

Thanks, William 


Jake
Employee
Forum|alt.badge.img+4
  • Employee
  • Answer
  • March 30, 2026

Hi ​@William Seath, do the original metric (FCT_Demand Forecasting) and test metric have a formula in them with overrides enabled?

The clone feature will only copy user inputs, including overrides of formula results. If your source Volume Type of Statistical Demand is formulaically derived, those values will not be included when cloning data. 


Forum|alt.badge.img+1
  • Author
  • Apprentice Author
  • March 30, 2026

@Jake that is exactly it, I can confirm that if  I overwrite values in Statistical Demand the values are copied over. The knowledge base mentions that clone data is generally used to initialise between versions, presumably this means that any non-user entered data must be done a different way?