History and Future Bucket of the Data View

[Former Member]

Hi Experts

As per my Client Requirement Planning for the Next year Jan 2010 u2013 Dec 2010 which Starts in the second Quarter of the Year 2009.

They need historical data (Historical Time Bucket) of Last 3 years in the monthly bucket and Future bucket for Jan 2010- Dec 2010.

My query in this regard to design Data view which need to Show Historical periods of Last 3 yrs from current month and Future Bucket as Jan 2010-Dec 2010 to input the Forecast.

The next planning Cycle would start in the second Quarter of the 2010 to forecast for the Jan 2011 to Dec 2011. When they plan for the Year Jan 2011 u2013 Dec 2011 the data views should be automatically roll or update with future bucket Jan 2011-Dec2011 and History Bucket with three years in the monthly bucket from the Current Month.

Please give your Valuable Suggestions with regard to above requirement.

I tried by Giving Planning Start Date as 01.01.2010 , but it is not fulfilling the above requirement.

[Former Member · Accepted solution]

Dont use the PLanning start date as this would keep your dataview static and not rolling.

What you need to do is create time bucket profiles one for past 3 years and another 2 years for future and attach these Time bucket profiles to the Dataview.

This will satisfy your requirement completely.

Time buckt profiles can be created with transaction /sapapo/tr30.

Please let me know in case of any more information

[Former Member · Accepted solution]

Hi Anuradha

Thanks for you reply.

If i Use 3 years in Months for the History Bucket and 2 years for the Future Bucket.

Assume that we are in the month of the Jannuary 2010 , in this case we history is Displayed from Jan 2007 to Dec 2009 and Future will be Displayed for the Jan 2010 to Dec 2011.

Here i am getting extra future buckets which is Jan 2011 to Dec 2011.I am still confused to handle this issue can you please elaborate

[Former Member · Accepted solution]

If you want it only till Dec 2010..maintain 1 year instead od 2 years in future

[Former Member · Accepted solution]

Hi Anuradha

Thanks for you quick reply.

Assume that we are in the Month of June 2009, My planners start the planning process for the Jan 2010 - Dec 2010.

If i take 1 year it wont help me , Future Buckets will be till May 2010.

If i take 17 Months as the Future Buckets , Future buckets are displayed till Dec 2010.

Till June 2010 In between Planners can have Revision , and may again change the Forecast.

Suppose Assume that we have revision in the month of March 2010 , Here Future Buckets are displayed till October 2011.

How to make my data view time bucket in the synchronized with future Periods.

Thanks in Advance

Mani

[Former Member]

Hi Mani,

"Data view which need to Show Historical periods of Last 3 yrs from current month and Future Bucket as Jan 2010-Dec 2010 to input the Forecast."

Does it work for you have 3 years in the past and 2 years into future in your time bucket profile. Just display the period for Jan2010 to Dec2010 and hide the rest of the periods. Use the macro COL_VISIBLE to hide the columns.

The periods are rolling so automatically the periods roll from Jan2011 to Dec 2011. if not, you can always just modify the macro directly in production.

Does the above suggestion work?

[Former Member]

Hi Visu

Sorry for the Delay.

Please advice me what time bucket profile i need to take to satisfy my requirement.

In the second Quarter of the every year they do forecast for the Next year.