/SAPAPO/MA119 – Column adjustment for varying TBP
You want the macro steps to roll automatically as the period changes – and I thought the requirement for this to tick the below check-boxes until lately when I have encountered a strange (not anymore) case.
Our data view has a history of 3 years and the future of 2 years. And we didn’t maintain any ‘Planning Start’ date in the data view settings (see below). This means, the planning start date will be considered as the current time-bucket.
In one of the macro steps, I was trying to tick the above check-boxes but with no success. Below is with what I ended up and the ticks I had done are being vanished!
After searching for the message is what I found this consulting note 674239. What I learnt is: these check-boxes come to use when you have varying periods for the data view in history or future as we roll over (“or” because if one of them changes, the other gets auto-changed).
In the above situation – we had first month in weeks, and the rest 23 months in months as our time bucket profile. When we were in week-x1 – we had in total 27 periods in future, and the same is being changed as we rolled over.
Let’s assume we have developed a macro in week-x2 – it then would have had 26 periods in future, and then it becomes 25 periods the very next week because of the time bucket profile we are using. This has the possibility of producing unexpected results (not each time, but it depends on the logic we are using) since the last column is 26th period when we developed the macro but is 25th period when we jumped to week-x3.
To avoid this confusion to the system, and to let the system actually understand what is the first period and what is the last period – we use these check boxes. The system then determines the first/last column during the runtime, and accordingly calculates the results thus avoiding the wrong doings.
Note: You can check these boxes only if you have one of the following time buckets in the user-defined periods (assume we are in week-x1).
- First column in the history (Month1),
- Last column in the history (Month18),
- First column in the future (Week-x1),
- Last column in the future (Month42).
Otherwise, get ready for /SAPAPO/MA119.