Overwrite and Delta options in Input schedules
We are planning to use 'Park and Go' feature of BPC and save some input schedule to our local machine. We will send these files to our endusers for offline planning. Endusers are not connected to BPC server. They dont have client installed on their machine. They will do offline planning and forward the input schedules to Planning coordinator. Planning coordinator will open these files in BPC and send those values to BPC server. In some cases, he has to add those values from input schedules to the existing data in server. In some cases, he has to overwrite the existing data with new data. He also needs Delta update option. These features are available for uploads using data manager. But are these options available during data sends using input schedules? Please suggest.
There is no such thing as a delta input in BPC. When you send data the new value is always the final value in the database. BPC looks into FACT, FAC2 and FACTWB partition to see if there are already values in the database and posts the difference between the values that exist and the new value that is sent. So if you entered 10 into the database already and someone provides a template that has 8 on that same intersection of dimensionmembers, BPC wil post -2 so the final value in your report will be 8 (because it combines 10 -2 in the report).