Best Practices: Configuring and reviewing user-defined Time Slice requests to avoid duplicate definitions

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

Summary:

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.

Instructions:

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. 

Analyzing Results:  

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.

SLICEIDSLICENAMEFROMDATENUMPERIODSEXPIRYDATETIMELASTRUNIS_SYSTEMPERIOD_TYPEFIELD_NAMERUN_FREQUENCYTABLE_NAME
4MONTHLYRESOURCEACTCURVE01-MAR-151201-MAY-1530-APR-151MonthlyActualsMonthlyPRJ_BLB_SLICES
5003002ReportingSelfBillingAct01-APR-151501-MAY-1530-APR-150MonthlyActualsMonthlyPRJ_BLB_SLICES
5005001Reporting - Monthly Actuals28-JAN-153629-APR-1528-APR-150MonthlyActualsDailyPRJ_BLB_SLICES
1DAILYRESOURCEAVAILCURVE25-JUN-1536525-JUL-1517-JUL-151DailyAvailabilityMonthlyPRJ_BLB_SLICES
5003003DailyTimesheetCalendar01-SEP-1436501-AUG-1517-JUL-150DailyAvailabilityMonthlyPRJ_BLB_SLICES
7MONTHLYRESOURCEAVAILCURVE01-JUN-151201-AUG-1517-JUL-151MonthlyAvailabilityMonthlyPRJ_BLB_SLICES
5003001ReportingSelfBilling27-JUN-153627-JUL-1517-JUL-150MonthlyAvailabilityMonthlyPRJ_BLB_SLICES
5005003CapacityManagementETC01-JAN-13801-JUN-1531-MAY-150YearlyEstimatesMonthlyPRJ_BLB_SLICES
5006001Program Status Report - ETC01-JAN-13801-JAN-1617-JUL-150YearlyEstimatesYearlyPRJ_BLB_SLICES

To remove a user-defined Time Slice request:

  1. Login to the application as an administrator user 
  2. Navigate to Administration, Time Slices Management page 
  3. Check the box next to the user-defined slice request
  4. Click 'Delete' button

Additional Information:

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

  

File Attachments:
TEC618280.zip