Overwrite and Delta options in Input schedules

[Former Member]

Hi,

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.

thanks/regards,

Lokesh Nandula

[Former Member · Accepted solution]

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

-Joost

[Former Member · Accepted solution]

Thanks Joost.

We are thinking of some alternatives to meet this requirement. We are planning to copy the offline plan data to a new version (Category) using data sends through Input schedules. We will use data manager package to copy these values from the new version to our original version. In data manager, we have the option to either add or overwirte the data. We can also automate this activity. Can you please suggest if this could be a perfect solution for our scenario.

regards,

Lokesh Nandula

[JHattendorf · Accepted solution]

Lokesh - another option to consider is using multiple data sources. The "overwrite" input schedules or even rows/columns of data could use a member like INPUT. The "delta" input schedules could use a member like "Adjust". The two data source members can then be added together in the hierarchy.

Good luck,

Jeff

[Former Member]

You could use any such value like "original" and "increment /decrement" to denote the delta values.

This works the same way as the old IP and BPS work in the plan value perpective.

Ravi Thothadri

[Former Member]

Thanks Jeff and Ravi.