Configuring the Data Warehouse Time Slices

book

Article ID: 145856

calendar_today

Updated On:

Products

STARTER PACK-CLARITY PPM Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

This article covers details on how to configure the DWH (Data Warehouse) Time Slices. Timeslices with the Data Warehouse option selected determine the ranges for the Data Warehouse facts. Data Warehouse time slice requests are system requests and cannot be deleted.

The Data Warehouse time slice requests default to the following time periods, which are based on the database server system date:

  • One year back and forward for Daily. The From Date of the slice request is one year before the system date.
  • One year back and forward for Weekly. The From Date is one year before the system date. The From Date is the same day as the First Day of Work Week defined under Administration,  Project Management Settings.
  • Three years back and forward for Monthly. The From Date is three years before the system date and is always the first day of the month.
  • Three years back and forward for Fiscal. The From Date is three years before the system date. The From Date is the start date of the fiscal period for the entity that is selected for the Data Warehouse. The fiscal period that is referenced is of type Monthly or 13 Period, whichever is set for the entity.

The entity must have Monthly (or 13 Period) fiscal time periods set up to cover the range of the time slice requests. Otherwise, the time slice requests are ignored when the Time Slice job runs.

Verify that the ranges work for your business needs. To update the From Date and Number of Periods, open a time slice and change the properties.

Environment

Release : All Supported Clarity Releases with Data Warehouse

Component : CLARITY DATA WAREHOUSE

Resolution

Rules for Setting the From Date and Number of Periods

By default, the Data Warehouse time slice requests are set consistently for each slice period (Daily, Weekly, Monthly, Fiscal). If you edit these slice requests, set the From Date and Number of Periods to be the same for each slice period type. If the From Date and Number of Periods are not set correctly, the data in the Data Warehouse is inconsistent.

Follow these rules when setting the From Date and Number of Periods for the Data Warehouse time slice requests:

  • Verify that there is only one daily time slice request.
  • For all weekly time slice requests, the From Date must be the same day as the First Day of the Work Week in the Project Management settings. For example, if the First Day of the Work Week is a Monday, then set all weekly time slice requests with a From Date that is a Monday.
  • For all monthly time slice requests, the From Date must always be the first of a month.
  • For all fiscal time slice requests, the From Date must correspond to the start date of a Monthly (or 13 Period) fiscal period type.
  • The time slice ranges must include the start and finish dates of the investments on which you regularly report. For example, if you have two-year investments, set the time slices to cover two years back and forward to include all relevant data in the Data Warehouse.

Example Fiscal Slices:

Example of Monthly slices:

Example of Weekly Slices:



Best practices:

  • Try to follow as close as possible the default configuration as this is the one that was tested for performance.
  • If you must increase periods, ensure that you do so with Fiscal/Monthly.
  • We do not recommend adding multiple years of data in past in future in Weekly/Daily periods.
  • Add any periods in Test environment, and ensure Time Slicing and Load Data Warehouse Full and Incremental perform to your satisfaction before making the change in Production
  • Important: Increasing the periods to multiple years in past and future is not recommended and may cause performance delays with Time Slicing and Load Data Warehouse job

Additional Information

Also check:

Attachments