Skip to Content
0
Former Member
Apr 20, 2007 at 12:54 AM

DP Technical Period and Weekly Bucket

121 Views

Hello All,

In our DP Planning Book, we have two data views Months and Weeks.

The issue that we are facing for few SKUs is that the numbers don't match between MONTHS and WEEKS data view.

In MONTHS view

Months Key Fig A

APR 4,845,869

MAY -5,109,015

JUN 224,846

In Weeks view

WEEKS Key Fig A

Week13 277

Week14 222

Week15 272

Week16 237

Week17 349

Week18 314

Week19 354

Week20 167

Week21 248

Week22 454

Week23 298

Now the two views do not really add up right. So when I check my same SKU in the TECHNICAL periods in the planning book, I see the following.

In Technical Period

TECH PER Key Fig A

4/01 37

4/02 222

4/09 272

4/16 237

4/23 349

4/30 4,844,752

5/01 -4,844,438

5/07 354

5/14 167

5/21 248

5/28 -265346

6/01 265800

So I found that wherever the week splits in two months, there is a very high number which makes the Month's value out of wack. This continues till the end of forecast horizon for all weeks.

One thing to be noted here is that the value in Key Fig A is copied from another Key Figure and that KF looks good.

As I am working to resolve this issue, I wanted to know if anyone has came across the same issue. Any thoughts/suggestions are also welcomed.

Thanks,

Sanju