Session Information
Click here to go to the previous page
Using ODS Freeze processes for Efficient Snapshot Comparison (4973)
Track: Business Intelligence & Performance Management
Program Code: 4973
LEAD PRESENTER / PANEL ORGANIZER / BOF LEADER :
Paul Johnson, Business Intelligence Administrator, Tulsa Community College
Description
This session will demonstrate Tulsa Community College's use of the BPRA data freeze process alongside customized scripts to facilitate efficient snap-shot comparison reporting. Using SunGard Higher Education's built-in freeze process for ODS tables, static detail data are captured for future comparison reports; however, when these freezes are requested daily, the tables become bloated and inefficient. TCC uses additional scripts to aggregate the frozen data and store it in new tables. The presenter will show how freeze event codes and aggregate tables can facilitate efficient and effective snap-shot comparison reports from the ODS.


Audio Synchronized to PowerPoint
(Code: 4973)
Attendee:Free
Virtual Attendee:$10 USD
Authorized NON-Attendee:$25 USD
  
This session is a part of:
Handout Online
(Code: 4973)
Attendee:Free
Virtual Attendee:Free
List Price:
  
This session is a part of: