- Connect to the Cubes DB using Analysis Services
- Launch SQL Server Management Studio (SSMS)
- Expand Integration Services Catalogs
- Expand SSISDB
- Expand Projects
- Right-click desired Cubes
- Select Configure...
- Find IntExtractStartYear; if missing, move on to step 7skip
- Select …at the end of IntExtractStartYear
- Select Edit value
- Input the start year for data retrieval
- Example: 2016
- Select OK
- Select OK
- Find DtExtractStartDate; if missing, move on to step 17
- Select …at the end of DtExtractStartDate
- Select Edit value
- Input the start date for data retrieval
- Example: 1/1/2016 2:00:00 AM
- Select OK
- Select OK
- Updates will take effect after the next cubes job completion
|