Skip to main content

Hi,

Can someone please tell me about the best practice for Data Cloning in metrics from one version to another such that even data which is the result of a formula gets cloned when new version is added? 

This is my find with regards to data cloning:
1) In formula driven metrics with manual override on, only manual inputs get cloned. Data resulting from formula does not get cloned.

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.