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

Document ID : KB000028482
Last Modified Date : 21/06/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, start of current week + 14 weeks into the future)

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 to the system. Even if there is time slice data that is outside those ranges, the system still limits the view to the ranges specified above.

 

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" (to view) ?
c. What is the "Time Period Offset" (shift from "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 range to view) ? 12 weeks
c. What is the "Time Period Offset" (shift from "Start Date")? 0

CA PPM will calculate the viewable weekly range to be

(2 weeks in the past, the start of the current week + 14 weeks into the future)

which translates to the range: Monday, July 23, 2018 to Monday, October 15, 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 range to view) ? 12 weeks
c. What is the "Time Period Offset" (shift from "Start Date")? -8

CA PPM will calculate the viewable weekly range to be

(2 weeks in the past, the start of the current week + offset + 14 weeks into the future)

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

which is [Monday, May 28, 2018] to [Monday, August 20, 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