Update the data stored in denormalized tables

You can change the number of weeks' worth of data stored in denormalized tables.

Avant de commencer

Role required: admin

Pourquoi et quand exécuter cette tâche

Avertissement :

You must be a system administrator and a professional developer to complete this procedure.

You can have a maximum total of 20 weeks' worth of data stored in denormalized tables, that includes the current week. For example, you can change the number of weeks from the default to 4 weeks in the past, and 10 weeks in the future, which would total 15 weeks worth of data stored in denormalized tables.

By default, the number of past weeks worth of data stored in denormalized tables is two weeks. By default, the number of future weeks worth of data stored in denormalized tables is 8 weeks.

If you customize and add data to Field Service Management from an external source, or enable or disable Workforce Optimization then you must follow the steps below.

Procédure

1. Navigate to All, type sys_properties.list, and press Enter.
2. Search for and select the denormalized table system property (sn_fsm.wm_weekly_resource_span).
3. Set the value to false, and select Update.
4. Choose from the following options:
   • Search for and select sn_fsm.wm_weekly_resource_span.number_of_ weeks_in_past – to change the number of weeks worth of data stored in the past.
   • Search for and select sn_fsm.wm_weekly_resource_span.number_of_weeks_in future – to change the number of weeks worth of data stored in the future.
   • Add an external data source.
   • Enable or disable Workforce Optimization.
5. Facultatif : Update the value from the default to the new number if you are changing a property value, and select Update.
6. Use the background script to truncate the weekly resource span table.
7. Search for and select the denormalized table system property (sn_fsm.wm_weekly_resource_span).
8. Set the value to true, and select Update.