Skip to Content
0
Former Member
Nov 27, 2013 at 05:38 PM

Disaggregation "doubling" up the value partial week-month

28 Views

Dear Experts,

A bit of weird case for which I cant find any config level solution.

KF1 is disaggregated based on KF2, both structurally and along time.

KF2 has value= 0 (not blank) across Jan14 to Dec14.

I enter a value in KF1 in TB = months e.g. Jan14 = 500, Feb14 = 600, March14 = 900

I view the values of KF2 in TB weeks and this is how it looks on data view = weeks

W.06.01.2014 100 W.13.01.2014 100 W.20.01.2014 100 W.27.01.2014 220 W.03.02.2014 120 W.10.02.2014 120 W.17.02.2014 120 W.24.02.2014 300 W.03.03.2014 180 W.10.03.2014 180

In the weeks split across consecutive months, I note that the values are sum of values of weeks on the either side

It is obvious to see what is happening but why will this happen and how to get rid of this obvious bad math.

Thanks

BS

PS: Storage bucket profile is weeks and months.