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

  4. Select at the end of IntExtractStartYear

  5. Select Edit value

  6. Input the start year for data retrieval

    1. Example: 2016

  7. Select OK

  8. Select OK

  9. Find DtExtractStartDate; if missing, move on to step 17

  10. Select at the end of DtExtractStartDate

  11. Select Edit value

  12. Input the start date for data retrieval

    1. Example: 1/1/2016 2:00:00 AM

  13. Select OK

  14. Select OK

  15. 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.

...