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?

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).
Hi
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.