Update the Retrieval Date for Cubes - OnPrem

There is no cubes data available beyond a certain date

• Tyler deploy 
• Datacenter
• Munis Cubes
• SSMS
• OnPrem

Cubes have been configured to retrieve data back to a specific date.

1. Connect to the Cubes DB using Analysis Services
2. Launch SQL Server Management Studio (SSMS)
3. Expand Integration Services Catalogs
4. Expand SSISDB
5. Expand Projects
6. Right-click desired Cubes
7. Select Configure...
8. Find IntExtractStartYear; if missing, move on to step 7
9. Select … at the end of IntExtractStartYear
10. Select Edit value
11. Input the start year for data retrieval
    1. Example: 2016
12. Select OK
13. Select OK
14. Find DtExtractStartDate; if missing, move on to step 17
15. Select … at the end of DtExtractStartDate
16. Select Edit value
17. Input the start date for data retrieval
    1. Example: 1/1/2016 2:00:00 AM
18. Select OK
19. Select OK
20. Updates will take effect after the next cubes job completion

Please note that this process will cause Cubes to run slower, as it is trying to pull in more data.

When installed, cubes pulls from the last 5 years automatically.