The information provided in this document serves as a Quick Start guide for users of the CCC Data Warehouse Report Server (“DW Report Server”, “Report Server”, “DWRS”), including:

• Getting started with the DW Report Server; requesting authorized access and implementation support

• User account set up and authentication processes

• Running preconfigured reports that pull data from the CCC Data Warehouse (currently limited to the LGBTQ report template)

• Querying available data sources, running ad hoc reports, scheduling and exporting results

• Creating custom Ad Hoc Views from which multiple reports can be run based on the following data sources:

  • California Colleges Promise Grant Application

  • CCCApply International Application

  • CCCApply LGBTQ Data (AB 620)

  • CCCApply Standard and Noncredit Applications

  • C-ID - Course Identification System

  • COCI - Chancellor’s Office Curriculum Inventory

  • MIS (post-processed files) - Chancellor’s Office Management Information Systems

  • Multiple Measures Placement Service (MMPS)

The DW Report Server is a secure, user-friendly reporting tool that creates reports, charts and dashboards using secure CCC Data Warehouse data.

• The CCC Data Warehouse is a structured source of primary data that can be used to generate the reports and analytics that end-users need.

• The DW Report Server is powered by JasperReports, a Java-based open-source reporting tool. JasperReports, connected to the CCC Data Warehouse, allows for advanced reporting usage and provides help that you can access from the Help link.

Access to the DW Report Server is restricted to authorized users to ensure the privacy and security of the data within the CCC Data Warehouse. Users must request access via one of the appropriate processes below and upon approval will be granted an account based on their user type.

• College and District Institutional Researchers: upon confirmation from their college or district Vice President, an identified lead IRPE Researcher at each college or district will be established as the authorized user and “gatekeeper” for their institution (organized by MIS Code). These “gatekeepers” can then request access for additional researchers at their institution by submitting an email request to ES Support Services or by contacting their College Experience Manager (CRM) with this information:

  • User’s Name

  • User’s email address (.edu)
    
    

    Open

    

    
    
    

• Chancellor's Office and Other External Stakeholders: All requests for access to the Data Warehouse Report Server from the CCC Chancellor's Office or other external stakeholder organization are to be directed to the CCC Data Warehouse Product Manager (Mark Cohen mcohen@ccctechcenter.org) who must obtain approval from the Vice Chancellor for Digital Innovation and Infrastructure at the CCC Chancellor’s Office.
  
  

Support is available to authorized Report Server users in our 24/7 online support community CCCTechnology.info, where college and district staff can share ideas, ask questions, and report bugs and issues for all the CCC Technology Center online applications.

Our experienced support engineers monitor all incoming posts and comments, Monday - Friday, 7:00am - 4:00pm PT. Depending on the nature of the issue or comment, support engineers will respond within 24 hours to critical issues regarding production applications.

This section includes:

• Getting Started

• User Accounts

• Set Up and Log In Processes

• Appendix A: Data Warehouse Report Server URLs

Establishing an authorized DWRS user account is a two-part workflow between a CCCTC Administrator and the approved user. An Enabling Services Implementation Configuration Engineer (ICE) will create and configure the account in our internal system and then work with the user to complete the final steps and log in, depending on the user type. This section of the document outlines the roles and responsibilities - and setup tasks - for the CCCTC Administrator and the approved DWRS user.

The first steps in getting started are:

1. Contact the CCCTC Enabling Services team to Request Access and initiate the implementation process.

2. Schedule a call with a CCCTC Administrator to facilitate implementation and configuration services.

There are two types of authorized user accounts:

• SSO Users: Colleges and Districts using their institution’s IDP for single sign-on. CCCTC does not manage your institution’s two-factor authentication (2FA) mechanism, if implemented.

• Non-SSO Users: CCCCO, CVCOEI, and other authorized external users will authenticate directly to the DWRS using 2FA to secure and protect our systemwide student data.