Update 3:  As mentioned last week. the Cognos / ODS composite tables and reporting views were out of sync with the ODS staging tables.  To fix the problem, we performed a re-load to the composite tables from the staging tables. Last weekend Finance, HR, and AR were re-loaded. This morning, Tuesday, 2/18, General was re-loaded. Following is the schedule for the remaining re-loads:

Tue., 2/18 at 7pm: Student
Wed. 2/19 at 7pm: Advancement
Thu., 2/20 at 7pm: Financial Aid

 

Update 2:  Further Cognos / ODS maintenance is required for the following areas: Finance, HR and Accounts Receivable

ITS will begin the  re-load maintenance process with Finance beginning this evening, (Friday – 2-14-14) at 7 PM, followed by HR and Accounts Receivable.  These re-load processes are expected to run for 24 hours.

Please note that all daily Cognos /ODS re-fresh processes will be suspended until the completion of the re-load maintenance.

 

Update 1: Despite taking longer than anticipated, as of 10:15 AM, the Cognos / ODS reporting tables were reconciled and the report data has been through two re-fresh cycles.

ITS has been working through the issues surrounding missing Banner extract data within the Cognos/ODS reporting environment.  As of 3:30 PM all of the Banner extracts to the Cognos / ODS reporting environment have been identified and are currently being addressed.  ITS will complete a full re-fresh of the Cognos / ODS reporting data beginning this evening and will perform the normal daily data re-fresh tomorrow morning during the ITS maintenance window and before regular business hours.

As with any system maintenance, if you should experience any Cognos / ODS reporting issues after these updates, please contact the ITS Help Desk at 740-587-6395 or helpdesk@denison.edu.