Skip to Main Content
Skip to Main Content.


OCFS Intranet

Data Warehouse Training Information

OCFS Data Warehouse Basic Training for Cognos 8

Pre-requisites: None

Time: Approximately 15 minutes

You can view a non-interactive Presentation of the training:

OCFS Data Warehouse Advanced Report Studio Training for Cognos 8

The OCFS Data Warehouse Advanced Report Studio Training is a one-day classroom training that provides hands-on instruction on creating and modifying reports in Cognos 8. Participants use a training database that contains a sample of the child welfare, CPS, FAD, and FASP information contained in the Data Warehouse. During the first part of the training, attendees learn how to select a data package, create a basic list report, and use the toolbar functions Group, Sort, Filter, and Aggregate. The second part of the training includes adding calculations, prompts, and formatting to the report. Finally, attendees learn how to create a crosstab report. Time is allotted for practice.

Pre-requisites: Only those who received the Report Studio license for their District/Agency may attend