The best way for CCC staff and faculty to contact the Support Services team at the CCC Technology Center is to visit http://CCCTechnology.info , the online support community for faculty and staff where you can post comments, questions, submit a change request, or request technical assistance.

Support engineers are monitoring every incoming post between Monday and Friday, 7:00am - 4:00pm PST. Reporting an outage or incident with a staff-facing or student-facing online application, you can send an email directly to Support Services at staffsupportccctc@openccc.zendesk.com.

If you are an authorized college or district user, you will go to a school/district login page and use the password provisioned to you for your other college/district systems. If you are a non-SSO user, you can use the “Forgot Password?” link to reset your password or contact ES Support Services to reset the password for you.

In September 2022, the CCCTC implemented a new secure system to authenticate Data Warehouse Report Server users. Pre-existing users have been migrated to the new secure system, but will need to work with the CCCTC Enabling Services team to re-validate their accounts. CCC college and district users will now log in via a custom URL and their institution’s IDP for single sign-on login. All other users, including Chancellor’s Office and CVC-OEI users, will continue to use the DWRS URL but must revalidate their existing account credentials.

IRPE Researchers: The identified lead IRPE Researcher at each college or district will be established as the authorized user and “gatekeeper” for their organization (MIS Code) upon confirmation from their college or district Vice President. Gatekeepers can then request access for additional researchers at their organization (MIS Code) by submitting an email request to ES Support Services with the information below.

Chancellor's Office and Other External Stakeholders: All requests for access to the Data Warehouse Report Server from the Chancellor's Office or other external stakeholders, must be directed to Mark Cohen, Product Manager, CCC Data, mcohen@ccctechcenter.org who will obtain approval from the appropriate CCCCO Vice Chancellor.

Please notify the research lead at your college or contact CCCTC Enabling Services directly at ES Support Services.

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

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

For Non-SSO Users (Chancellor’s Office and CVC-OEI authorized users): Yes. Please contact the ES Support Services team at the CCCTC to obtain a new temporary password for your user account from a CCCTC Administrator. Once the account has been re-verified, you can change the password using the “Forgot Password?” link on the Login page. If you have trouble using the “Forgot Password?” feature, please contact ES Staff Support to request assistance at staffsupportccctc@openccc.zendesk.com.

For SSO Users: (Colleges and Districts): No. You are no longer required to enter a password when accessing the DWRS through your institution’s IDP (SSO). To reset your local password, please contact your college or district IT department.

For Non-SSO Users Only: A verification code is required as the second factor used in two-factor authentication for non-SSO users only (the password is something you know, and the verification code is something that you obtain). This additional step helps to secure data in the DW Report Server.

For Non-SSO Users Only: A new verification code is generated in the Authenticator app software you installed on your desktop or mobile device during the implementation process. After entering your email and password credentials, continue to the “One-time code” screen. Open your Authenticator app and copy the six-digit verification code that is generated for the Data Warehouse Report Server. Enter the code in the “One-time code” field before the code expires (30 seconds).

For Non-SSO Users Only: The verification code is time-sensitive code designed to time out after 30 seconds. Each newly generated code appears with a timer, counting down to expiration. Give yourself enough time to copy the code and return to the sign in process before the code is no longer valid.

The Data Warehouse Report Server (DW Report Server) is an easy-to-use reporting tool that pulls data from the CCC Data Warehouse.

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

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

The CCC Data Warehouse is a structured database while the Data Warehouse Report Server is an analytics software package connected to that database providing an interface to query and extract data.

The Data Warehouse may be accessed through the Data Warehouse Report Server, or through a Direct Connection to the Data Warehouse.

The Data Warehouse Report Server is a CCC-branded version of TIBCO JasperReports Server (v.7.8.0) with role-based access to integrated CCC Data for authorized CCC researchers using single sign-on (SSO).

TIBCO JasperReports Server is a comprehensive Business Intelligence (BI) tool that provides robust static and interactive reporting, report server, and data analysis capabilities. A comprehensive Help system is available and can be accessed from any screen in the upper right toolbar. The Help system provides high-level descriptions of feature functionality and step-by-step instructions for how to extract the data and insights you need from your data.

Two-Factor Authentication (2FA), a subset of multi-factor authentication (MFA) is a security system that authenticates a user’s identity by requiring multiple pieces of evidence (credentials) before granting access to a service or system.

Multi-Factor Authentication (MFA) is a security mechanism that requires users to provide two or more independent credentials to verify their identity when logging into a system, application, or account.

These credentials fall into three categories:

1. Something you know – e.g., a password or PIN

2. Something you have – e.g., a smartphone, hardware token, or smart card

3. Something you are – e.g., fingerprint, facial recognition, or other biometrics

Example:

When you log into your database account:

• First, you enter your password (something you know)

• Then, you get a code on your phone via SMS or an authenticator app (something you have)

Only after successfully providing both are you granted access.

The following data sets are currently available in the Data Warehouse Report Server (as of CCC Data v.2.2.0):

• CCCApply Standard and Noncredit Applications

• CCCApply LGBTQ Data (AB 620)

• CCCApply International Application

• CC Promise Grant Application

• Multiple Measures Placement Service (MMPS)

• MyPath

• Chancellor’s Office Curriculum Inventory (COCI)

• Bi-Directional Fraud

• Course Identification Numbering System (C-ID)

Data sources that are available in the Data Warehouse, but NOT available in the Data Warehouse Report Server include:

• Canvas 2

• CTEOS

• Launchboard Adult Education

• Launchboard DST Web

• Student Journey

Authorized DWRS user types and access levels are defined in the Data Warehouse Report Server User Guide.

Yes. We will notify you as additional data sets are scheduled to be added.

There are several reports available, including:

• LGBTQ report developed in support of AB620

• Daily Fraud Status Report

• Submitted Applications Report

• Veterans Services Requested Report

To view ready-made reports, go to View>Repository, then click on Reports.

Approved IRPE researchers at each college or district will be established as the authorized user and “gatekeeper” for their organization (MIS Code) upon confirmation from their college or district Vice President. Gatekeepers can then request access for additional researchers at their organization (MIS Code) by submitting an email request to ES Support Services.

Communication will be provided as additional data sources are scheduled for release.

The Data Warehouse Report Server User Guide is stored in the CCC Data Warehouse Public Documentation space.

SSO Users (college and district users) are provided a custom URL based on the institution’s IDP for single sign-on. College and district URLs can be found in https://cccnext.jira.com/wiki/spaces/DWPub/pages/2780266497.
Non-SSO Users (all other authorized users) will continue to use the Data Warehouse Report Server URL.

The “first-time user log in” process pertains to Non-SSO Users ONLY. Non-SSO Users must complete this one-time process in order to authenticate their new account with the DWRS secure system. After completing the first-time process, Non-SSO Users need only use the Verified User Login process to access the DWRS.

SSO Users: College and district users will log in using the credentials set by their institution’s single sign-on (IDP) mechanism. For more information, please contact your College Relationship Manager (CRM) at crms@ccctechcenter.org.

Non-SSO Users: Chancellor’s Office and other external users are provided account credentials and temporary password during the implementation process between the user and the CCCTC Enabling Services implementation team. To contact the ES implementation team, please contact your College Relationship Manager (CRM) at crms@ccctechcenter.org.

The Organization (MIS Code) is the number assigned to each college and district by the Management Information System Division of the California Community Colleges Chancellor's Office. Each district and college has a unique three-digit MIS code number identifying their college. This code is added as an attribute by a CCCTC Administrator and will show in JasperReports after initial successful login.

The Username or Email field, which appears on the Log In page, is a text input field requiring the authorized user’s institutional email address (.edu).

Non-SSO Users: Chancellor’s Office and other external users are provided a temporary password during the implementation process. See the Non-SSO Users: Account Setup and Log In Process in the Data Warehouse Report Server User Guide.

College and district users (SSO Users) will log in using the credentials and password set by their institution’s single sign-on (IDP) mechanism. For more information, please contact your College Relationship Manager (CRM) at crms@ccctechcenter.org.

The “Scan QR Code” page is a step in the first-time user log in process (one-time process), required for Non-SSO Users only. See the Data Warehouse Report Server User Guide for details.

Scanning the QR code during the first-time user log in process depends on the Authenticator software you have installed on your desktop device. See the Data Warehouse Report Server User Guide for details.

Scanning the QR code during the “first-time user login” process depends on the Authenticator software you have installed on your mobile device. See the Data Warehouse Report Server User Guide for details.

After scanning the QR code for the first time, you will see a six-digit code displayed in your authenticator software app installed on your desktop or mobile device.

Open

The code will appear for 30 seconds before it refreshes to show a new code. Copy the code before it times out and paste it into the One-time code input field, then click “Submit”.

Open

Once logged into the Data Warehouse Report Server, navigate to the “View > Repository” and open the Public folder to find the LGBTQ folder.

Open

Yes. See the image above to locate the ready-to-run report template for your LGBTQ data.

To customize the LGBTQ report, you must locate and edit the original ad hoc View that was created and saved as the Report. Once you locate the corresponding View from the corresponding Public view folder, highlight the row of the View you want to customize and click the “Copy” button in the navigation menu. Locate your college or district folder and Paste the View there to unlock the permissions. Once unlocked, double-click on the file to open the View in the Ad Hoc Editor.

To schedule a report to run on a one-time or recurring basis, locate and click on the report from a folder in the Repository or from the list of available reports in the Library, then right-click to display the Schedule function from the menu. Follow the steps outlined in the Scheduling Reports section in the Data Warehouse Report Server - User Guide or access the Help section in the DWRS utility menu.

Open

How do I export report data out of the Data Warehouse Report Server?

To export data from a report in the Data Warehouse Report Server, run the Report that you want to export and click on the Export icon adjacent to the Save icon. A menu of file format options will appear. The selected file format will download to your local download drive.

Open

If you or your college has already completed the process to set up and authenticate your Data Warehouse Report Server user account, you should contact College Support Services at staffsupportccctc@openccc.zendesk.com.

The Data Warehouse Report Server User Guide provides basic, end-user training support for authorized users.

Please contact CCCTC College Support Services at staffsupportccctc@openccc.zendesk.com.