Skip to Content
0
Jun 04, 2018 at 03:06 PM

Snapshot of budget from APO

199 Views

Hi BW gurus,

We do production planning and we load budget data in APO every quarter (4 times in a year).

We pull this budget in BW for planning purpose from APO side.

Lets says there are 4 budget version in a year B1, B2 , B3 and B4. Note that the current budget version gets updated every day in APO side for the current quarter.

On the APO side we dont keep the previous version of the budget as soon as we have the new version. I want to make sure that I keep copies of all the budget version in BW even though it is deleted from APO side.

Currently when I load budget in BW from APO I do drop and load (full delete and load in the cube) for the current version as the current version gets updated every day until the budget planning exercise is completed for that particular quarter.

How can I take and keep the snapshot of the APO budget in BW which is no longer current, that means last update from APO side needs to be kept in BW, remember budget gets updated every single day in APO for the current version thats why we do drop and load but it is not possible for the older version of the budget thats why we need to take the snapshot of older version.

Your help will be appreciated

Thanks