Data Cloning

Something seems awry in your process. I just tested in my environment and it worked fine. Are you using the Clone Data menu option in the source dimension?

 

​@Bill in North Carolina ,

Yes, I am using the Clone Data menu option in the source dimension. 

 

In this test metric I want to clone data from AugRF to Test. The metric is formula driven and has metric override on.
 

This is the configuration I went with for cloning data
 

After cloning the result is blank for Test version. 
 

I overrode the value for ‘Unmapped → 1 → AugRF’ to 12. Now when I clone again this is my result 👇
 

Your challenge is that Item 3 Metrics: you only have the source of Test. You need to copy the upsteam metics too.

If the formula driving Test has data in AugRF, then when you copy the formula, it likely is looking for data in Test scenario.

You may be better off with metric to metric copy instead

Indeed, “Clone data to” only copies inputs (so overrides), not formula results. You will need to use “Metric to Metric” import instead (chained with Data flows if several metrics). This will copy all values, including the calculation results, into the target metric (or a different slice of the same metric, like another version).

​@Jérémie , I tried this workaround, but it seems to work only with Scenarios. It gives me the capability to perform metric to metric import within the same metric from one scenario to another but not versions.

Hi ​@tjain02 ! 
In your case, when trying to use Metric-to-Metric import, does the source metric match the target metric in terms of dimensions and data type? 
Per the documentation in this article - 

 - in addition to importing data from one Scenario to another inside the same Metric, we should also be able to import data between 2 different Metrics, if they have the same dimension and data type. 
Does that fit your use case?  

Hi ​@David Browne , I wanted a workaround where I could clone data within same metric, version to version in such a way that in addition to manual inputs, formula results also get cloned at a go for multiple metrics just like clone data feature allows cloning data for all metrics.

If you use clone data on the upstream metrics, it will address your need. If A = B + C, and you want to clone data for A, you need to clone data for B and C. If A allows overrides, then you need to clone data for A, B, and C, just in case. You can create a data action (i.e., a repeatable process) for the clone data job. You simply select your anchor dimension (in this case, Version), then set the source and target items (hard-code or have them prompt when run), then choose the metrics that should be cloned.

Metric-to-metric import is a whole other beast. I don’t think it’s what you’re looking for right now.