CA PPM: Warning message "The time periods requested do not exist. Review the column's Time Scale settings"

Document ID : KB000028482
Last Modified Date : 24/07/2018
Show Technical Document Details
Issue:

When trying to scroll through a portlet grid or after changing time-scaled view configurations within views/portlets such as

-Home > Project > Team > Detail

-Home > Resource > Allocations > Detail

The warning is received: "Alert: The time periods requested do not exist. Review the column's Time Scale settings".

This is not an error message.
 

Cause:

There are external and internal slices that exist in PPM.
Internal slices are not exposed in the Administration > Data Administratrion > Time Slices page, due to potential performance issues.

The internal slices feed various grid (time-varying) portlets in CA PPM. By design, there will be a limited window of data to view, i.e.

Quarterly: 12 periods (4 quarters in the past, start of current quarter + 8 quarters into the future)

Monthly: 36 periods (12 months in the past, start of current month + 24 months into the future)

Weekly: 16 periods (2 weeks in the past, the current week + 13 weeks from the current week)

Daily: 28 periods (7 days in the past, start of current day + 21 days into the future)

These data ranges may not be changed by end users nor through customization.

 

Resolution:

A. The start date that is chosen, be it rolling or specific, must fall within the date ranges listed above.

The current start date determines the total date range to view.

B. Review the Configure > Time-scaled value page and provide the following:

a. What is the "Start Date" field set to?
b. What is the "Number of Time Periods" (total to view in the scale) ?
c. What is the "Time Period Offset" (to shift from the 'Start date')?

C. Use the following link as a reference to a calendar calculator:

https://www.timeanddate.com/date/dateadd.html

An example, using the weekly time-scaled view is:

Given current start of week is: Monday, July 23, 2018

a. What is the "Start Date" field set to? Monday, July 23, 2018
b. What is the "Number of Time Periods" (total to view in the scale) ? 12 weeks
c. What is the "Time Period Offset" (to shift from the 'Start date')? 0

CA PPM will calculate the viewable weekly range to be

(2 weeks in the past, the current week + 13 weeks from the current week)

which translates to the range: Monday, July 23, 2018 to Monday, October 21, 2018

An example, using a weekly time-scaled view with an offset is:

a. What is the "Start Date" field set to? Monday, July 23, 2018
b. What is the "Number of Time Periods" (total to view in the scale) ? 12 weeks
c. What is the "Time Period Offset" (to shift from the 'Start date')? -8

CA PPM will calculate the viewable weekly range to be

(2 weeks in the past, the current week + [offset]  + 13 weeks from the current week)

which translates to the range: [Monday, July 23 , 2018] + [-8 weeks] + 13 weeks into the future

which is [Monday, May 28, 2018] to [Sun, August 26, 2018]

Additional Information:

NOTE: There is an Approved Time Slice Extension, which can be requested to increase the ranges, however it is still a limited view to protect against potential performance issues.

https://communities.ca.com/message/241754790#241754790
CA PPM Tech Tip:  Extend Time Scale Value Periods