APO DP: TBP : Fixed and Rolling

[Former Member]

Hello,

Our requirement is to have a Time Bucket Profile which is Fixed for certain time and rolling after certain time.

For example:

In M1 2008, the past data visible is from M1 2007 to M12 2007

However when we move to M2 2008 if we set rolling TBF the past data visible is from M2 2007 to M1 2008.

But, requirement is past data visible should be from M1 2007 to M1 2008 in M2 2008. And it should be like this till we go to M12 2008. i.e. Past Data Visible is M1 2007 to M11 2008 in M12 2008.

Now once we move to M1 2009, the past data visible should be from M1 2008 to M12 2008 and so on.

Is it possible to achieve this by standard ways?

If yes,Kindly guide how we can achieve this?

If No, what are the other ways of doing this?

Thanks.

[Former Member]

the simplest way is to manually maintain the Data view once a year and channge the Visible from and Input from fields in the data view to M012007. Dont think this rolls unless you set an offset.

so mark 31st in the maintainance calendar to change this

if you want to do it the hard way -

Keep your planning area with planning bucket profile extending to say 2 years

then check which year you are on by using the macro Year(today). you should get 2008 which you can save as say, CURRY ( no pun intended insto some layout variable

then use this value in a macro that says

if Year (Bucket_Bdate( any Row) is not equal to CURRY-1

then use Column_Invisible()

[srinivas_krishnamoorthy]

This is technically a very complex requirement. I would advise pursuing other options. Try to understand the underlying purpose of this requirement. If the purpose is to have adequate visibility in the dataview, you can always have appropriate sufficiently long enough planning area initialization and data view time bucket profiles. It is possible to switch from a monthly to an yearly view in the same data view. So you may need to help us understand more this req.

[Former Member]

Ideally you should have the administrator maintain the Data view Plan From/ Visibile from date every change.... but if you want to automate it....you can write macros which will open or close the columns

and use the concept of making columns invisible based on the current system date

have a longer horizon in the buckets..... check on the bucket date and if it passes the condition makes it visible else its invisible...

have a look at Bucket_bdate(), Today() and Column_invisible() macros