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 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.
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.
