Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleContext
  • Tyler deploy 
  • Datacenter
  • Munis Cubes
  • SSMS
  • OnPrem
Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleCause

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

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleResolution
  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
  1. desired Cubes
  2. Select Configure...
  3. Find IntExtractStartYear; if missing,
move on to step 7
  1. skip
  2. Select at the end of IntExtractStartYear
  3. Select Edit value
  4. Input the start year for data retrieval
    1. Example: 2016
  5. Select OK
  6. Select OK
  7. Find DtExtractStartDate; if missing, move on to step 17
  8. Select at the end of DtExtractStartDate
  9. Select Edit value
  10. Input the start date for data retrieval
    1. Example: 1/1/2016 2:00:00 AM
  11. Select OK
  12. Select OK
  13. Updates will take effect after the next cubes job completion
Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleAdditional Information

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.

...