Skip to Content
0
Former Member
Feb 26, 2009 at 07:16 AM

APO DP, mass updates of key figures, options?

71 Views

Hello all.

Due to the financial downturn we're facing the need to adjust a whole lot of cvc's downward in our DP setup

.

We have a setup with around 50.000 CVC's, and a great many of them need to be adjusted. We have a key figure that takes percentages as input, and we then use that to calculate how much to adjust a given key figure. Generally we want to adjust a given selection by a fixed percentage (10, 20, 30% etc.)

As mentioned we want to mass update these key figures (potentially 1000s of CVC's) since it's both work intensive and error-prone to do this manually.

Does anyone have any experience with doing mass updates of key figures in DP?

I was thinking about building some macros that could do the update for the relevant time period and the relevant selections, it would probably work. But is there some other way to do this?

It is a little scary for me to run update macros on 1000s of CVC's 😊

I was looking at the distribution and realignment functions too but they don't seem to be quite what we need.

Any experiences to share?

Edited by: Simon Pedersen on Feb 26, 2009 8:19 AM