We want to create some additional user-defined Time Slice Definitions. What 'Best Practices' or information is helpful in managing and defining Time Slice Definitions?
This article will help you identify stock, out-of-the box Time Slice Definitions that already exist and any user-defined slices so that you can review the current configuration and manage your Time Slice Definitions to avoid creating duplicate time slices.
The bulk of the processing time the Time Slicing job takes is due to deleting and inserting the slice data rows. Therefore to ensure the job runs efficiently limit the range and numbers of periods of time slice data. Avoid Time Slice requests that define the same type of data for the same period time. These would be considered duplicate slice requests, as they would most likely cover the same range. For example, having 2 Time Slice requests that process Actuals for Weekly periods would be considered duplicate requests. As a best practice, one of the slice requests should be deleted. In the cases where the duplicate involves a custom slice request and a stock slice request, the stock slice request should be the one to keep.
Identify Duplicate Time Slices:
Download this attachment file TEC618280.zip. It contains a SQL query and a workbook with sample results.
Execute the SQL query to compare the existing Time Slice requests with user-defined slices configured for the same 'field name' and same 'period type'.
Examine the results of the SQL query.
Looking at the (sample) results, you can see that some user-defined slices have been created which match a system-defined slice (IS_SYSTEM=1). The user-defined slices (IS_SYSTEM=0) should be reviewed to see if the data is used in any portlets or reports. If so, consider changing them to use the system-defined slice data and remove the user-defined slice. By cleaning up the list of Slice Definitions, you will improve the Time Slicing job performance and reduce the amount of redundant data stored in the database.
|5005001||Reporting - Monthly Actuals||28-JAN-15||36||29-APR-15||28-APR-15||0||Monthly||Actuals||Daily||PRJ_BLB_SLICES|
|5006001||Program Status Report - ETC||01-JAN-13||8||01-JAN-16||17-JUL-15||0||Yearly||Estimates||Yearly||PRJ_BLB_SLICES|
To remove a user-defined Time Slice request:
For additional 'Best Practices' in configuring and managing Time Slice Request definitions, refer to the following articles:
TEC435572: How should I configure my Time Slices?
TEC435563: Timeslice Terminology Explanation