{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":15418,"path":"field-service-management/workforce-optimization-for-field-service/denormalized-data-weeks.md","title":"Update the data stored in denormalized tables","bundle":null,"doc_type":null,"release":"australia","body":"\n# Update the data stored in denormalized tables\n\nYou can change the number of weeks' worth of data stored in denormalized tables.\n\n## Before you begin\n\nRole required: admin\n\n## About this task\n\n**Warning:** You must be a system administrator and a professional developer to complete this procedure.\n\nYou 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.\n\nBy 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.\n\nIf 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.\n\n## Procedure\n\n1.  Navigate to **All**, type `sys_properties.list`, and press Enter.\n\n2.  Search for and select the denormalized table system property \\(sn\\_fsm.wm\\_weekly\\_resource\\_span\\).\n\n3.  Set the value to **false**, and select **Update**.\n\n4.  Choose from the following options:\n\n    -   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.\n    -   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.\n    -   Add an external data source.\n    -   Enable or disable Workforce Optimization.\n5.  Update the value from the default to the new number if you are changing a property value, and select **Update**.\n\n6.  Use the background script to truncate the weekly resource span table.\n\n7.  Search for and select the denormalized table system property \\(sn\\_fsm.wm\\_weekly\\_resource\\_span\\).\n\n8.  Set the value to **true**, and select **Update**.\n\n\n"}}