Skip to Content
Former Member
Mar 06, 2009 at 12:09 AM

History and Future Bucket of the Data View


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.