How does the table RPT_CALENDAR update?

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

We are using this table to calculate FTE, but the date range is not what we need.

How do we modify this?

Environment

Clarity 16.1.2, 16.2.2, 16.2.3, 16.3.0

Resolution

The data in RPT_CALENDAR populates from stored procedure rpt_calendar_sp.

which can be deduced from the job's Update Report Tables stored procedure RPT_SETUP_SP

It uses the DWH slices to determine the date range.

If daily data needs to have a larger range in that table, increase the From Date or number of periods for the 55555 Daily Slice depending if you need more data from the past (change from date) or want more into the future (change number of periods)

RPT_CALENDAR table holds DAILY, WEEKLY, MONTHLY, ANNUALLY, QUARTERLY Start and End Dates as well as FTE (hours in the period)

For instance DAILY PERIOD_TYPE = 8 FTE

WEEKLY = 40

MONTHLY are based on the number of days in the period.

This table is also used to populate the PPM view DWH_COM_PERIOD_V which in turn populates various period views in DWH.  These DWH views are then used to calculate FTE in domains and reports.

Additional Information

It is important to also ensure that all Data Warehouse slices are consistent and cover the period you wish to report on.