Forum Discussion

Montreux's avatar
Montreux
New Contributor III
2 years ago

Copy Data Data Management Step and Derived Real Data

I have an input sheet in which data can be entered for an override of another number.  The Cell Status "Is Real Data" flag is used in a rule.  If an override is entered in the early part of the month...
Finance
  • JackLacava's avatar
    JackLacava
    2 years ago

    I guess it's because you're asking to copy the following periods too. If you only copy data from/to the dataunits where there are actual records, the results will be the same; if you copy the following periods, which point at different dataunits, I understand Copy Data will look to copy each dataunit individually, so if a source dataunit has nothing, a new record will be created for the target dataunit containing zero - because the copy has to happen no matter what (I think - you can ask Support for the details).

    Your use case might work better with a Scenario Formula instead, or using Hybrid Scenarios.

JackLacava's avatar
JackLacava
Honored Contributor

I suspect the problem is not copying data, but differences between Scenario configurations.  Can you post the Settings section of source and target Scenarios, as well as the Source View and Destination View of your DataManagement step?

Montreux's avatar
Montreux
New Contributor III
2 years ago

Sure, here is the DM job for Copy Data, 

And here are the settings of the basecase and target scenarios, 

Here is the copied scenario's cell status, Simulation 2,

Here is the original scenario, Basecase,

 

  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 years ago

    I guess it's because you're asking to copy the following periods too. If you only copy data from/to the dataunits where there are actual records, the results will be the same; if you copy the following periods, which point at different dataunits, I understand Copy Data will look to copy each dataunit individually, so if a source dataunit has nothing, a new record will be created for the target dataunit containing zero - because the copy has to happen no matter what (I think - you can ask Support for the details).

    Your use case might work better with a Scenario Formula instead, or using Hybrid Scenarios.

    • Montreux's avatar
      Montreux
      New Contributor III
      2 years ago

      Ok, a derived/ notReal zero would be what I would expect from the copy process, not a notDerived/real 0.  I will write a rule to copy data going forward.  Thanks.