Clarity: PMO - Capacity vs Demand Report for WEEKLY intervals shows all zeros

Document ID : KB000051562
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When I execute the PMO Accelerator 'Capacity vs Demand' Report By Resource or By Role, for MONTHLY periods, I see data in the report.

When I execute the report for WEEKLY periods the resources and portfolios are showing up but the data shows all zeros.

Solution:

The reason the report is showing all zeros is due to the Time Slicing Definitions used by this report.

The Capacity vs. Demand Report uses the following Time Slices:

Monthly:

MONTHLYRESOURCEACTCURVE
MONTHLYRESOURCEALLOCCURVE
MONTHLYRESOURCEAVAILCURVE

Weekly:

WEEKLYRESOURCEACTCURVE
WEEKLYRESOURCEAVAILCURVE
WEEKLYRESOURCEALLOCCURVE

This report uses the Datamart Calendar which uses a standard ISO week interval of Monday to Sunday. (Reference TEC435578)

Therefore, the Weekly Time Slices MUST have a start date for a MONDAY.

Reset the Time Slice Definition to start on a Monday and ensure the Start Date is set to cover the period you want to generate report data.
Execute the 'Time Slicing' job.
Execute the 'Datamart Extraction' job.
Generate the report again using the 'Weekly' option.

More Information:
If Weekly Time Slice Definitions are not setup for starting on a Monday, other issues may manifest throughout the application. The Time Scaled Values grids also use the Datamart Calendar Table to display data and may cause data to display incorrectly if the configuration is not correct.

Keywords: CLARITYKB, cap v dem, cap vs dem, NBI_DIM_CALENDAR, RPT_PMO_Cap_vs_DemandByRes, RPT_PMO_Cap_vs_DemandByRole.