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:
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.
Release : All Supported Clarity Releases with Data Warehouse
Component : CLARITY DATA WAREHOUSE
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:
Example Fiscal Slices:
Example of Monthly slices:
Example of Weekly Slices: