Skip to main content
M
Montreux
November 22, 2023
Solved

Copy Data Data Management Step and Derived Real Data

  • November 22, 2023
  • 1 reply
  • 1 view

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 monthly year but not later parts a derived amount of 0 is shown and it's "Is Real Data" flag is false. 

My problem is when I use the Data Management step Copy Data to copy to a new scenario.  The 0 cells after the initial user input are now "Is Real Data" = True and "Is Derived Data" = False.  My rule now treats these 0s as if they were entered by user and so doesn't work.  This seems very wrong to me that the Copy Data step can't get the details of the Cell Status right.  

Can someone explain what to do here to preserve the cell status after a copy?  Thanks.

    Best answer by JackLacava

    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.

    1 reply

    J
    JackLacava
    November 25, 2023

    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?

    M
    MontreuxAuthor
    November 27, 2023

    Sure, here is the DM job for Copy Data, 


    Montreux_0-1701071470721.png

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


    Montreux_1-1701071560832.png


    Montreux_2-1701071667847.png

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


    Montreux_3-1701072161700.png

    Here is the original scenario, Basecase,


    Montreux_4-1701072225114.png

     

    J
    JackLacavaAnswer
    November 27, 2023

    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.

    Terms & ConditionsAccessibility statement