Navigating to Administration > Security and Diagnostics > Health Report > Summary > Data Warehouse,
the Status shows a Red X.
There is a Fix It link, however it only takes it to the Administration > Data Administration > Time Slices page but does not autocorrect the issue.
The time slice IDs in question do not all uniformly start on the designated first day of the work week set in Administration > Project Management > Settings
AND
have the same number of periods.
Release : 15.8.1
Component : CA PPM SAAS TIME SLICING
When setting up the DWH time slices from the
Administration > Data Administration > Time Slices page, ensure that the start date
AND the day of the week that matches that of the Administration > Project Management > Settings > General > First Day of Work Week
AND have the same number of periods
1. Use the following queries to quickly find out what the days are set to:
--a
select sr.id, sr.request_name, SR.FROM_DATE, SR.PERIOD, sr.num_periods
from PRJ_BLB_SLICEREQUESTS SR
where SR.IS_DWH_REQUEST = 1
and SR.PERIOD = <xxxx> --where xxxxx designates the period type
order by SR.id
The field 'Period' is designated as follows:
0 = daily
1 = week
3 = month
--b
select prweekstart from PRSITE
0 - Sunday
1 - Monday
2 - Tuesday
3 - Wednesday
4 - Thursday
5 - Friday
6 - Saturday
2. Reslice the DWH slice request to start on a day consistent with the First Day of Work Week set in Administration > Project Management > Settings
Go to Administration > Data Administration > Time Slices page
Modify all the Weekly DWH time slice IDs to conform to the First Day of Work Week day:
Sort all the weekly DWH time slices by ID.
Open each ID link in a new browser tab.
Set the From Date to match the 'First Day of Work Week'
Monthly Slices that need to start on the same day/date and have the same number of periods.
4 MONTHLYRESOURCEACTCURVE
5 MONTHLYRESOURCEESTCURVE
6 MONTHLYRESOURCEALLOCCURVE
7 MONTHLYRESOURCEAVAILCURVE
305 MONTHLYBASEASSIGNCOSTS
312 MONTHLYRESOURCEBASECURVE
1000007 MONTHLYRESOURCEHARDALLOC
1000008 assignment::etccost_curve::dwh_month
1000010 baseline::current_team_usage::dwh_month
1000011 baseline::current_team_cost::dwh_month
1000012 team::hardallccost_curve::dwh_month
1000013 assignment::actcost_curve::dwh_month
1000014 team::alloccost_curve::dwh_month