Data Warehouse Report Server - Frequently Asked Questions

The following Frequently Asked Questions pertain to the Data Warehouse Report Server (v.1.4.1), released to production on August 14, 2020.

 

Most Frequently Asked Questions

How do I contact Support Services for college staff?

The best way for CCC staff and faculty to contact the Support Services team at the CCC Technology Center is to visit CCCTechnology.info, the online support community for faculty and staff, and post a comment, ask a question, submit a change request, or make a request for 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- or student-facing online application, you can send an email directly to Support Services at staffsupportccctc@openccc.zendesk.com.

Why are my user DW Report Server account (login credentials) no longer working? Did something change?

With the release of CCC Data v1.4.1 the DW Report Server is now secured through two-factor authentication. To do this we needed to retire the existing account access to the DW Report Server (and LGBTQ Report) and ask that new accounts be created.

I’m getting an error page when I try to login to the Data Warehouse Report Server. Did the URL for change?

In August 2020, authorized users setup prior to the CCC Data v.1.4.1 release Data Warehouse Pilot Report Server user accounts have

How do I request user access to the Data Warehouse Report Server?

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.

Process for Gatekeepers to Request Additional Users
Authorized gatekeepers may submit an email request with the new user’s name and email address (.edu) to CCC Technology Center Enabling Services - Support Services at staffsupportccctc@openccc.zendesk.com.

Chancellors Office & Other External Stakeholders: All requests for access to the Data Warehouse Report Server from the Chancellors Office or other external stakeholder, must be directed to Mark Cohen, Product Manager, CCC Data, mcohen@ccctechcenter.org who will obtain approval from Vice Chancellor, Barney Gomez, bgomez@cccco.edu.

I'm no longer working as an IRPE for the California Community Colleges. Who should I notify to remove my user access?

Please notify either the Research Lead at the college that you worked for, or contact Enabling Services directly at

How do I report a bug or issue with the Data Warehouse Report Server?

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 PST. Depending on the nature of the issue or comment, support engineers will respond within 24 hours to critical issues regarding production applications.

How do I reset my Password for the Data Warehouse Report Server?

The unique password is configured by a CCCTC Administrator for the user account cannot be changed or reset by the user. If you’ve forgotten your account password - or if your account has been compromised and you need a replacement password, please contact ES Staff Support to request assistance at staffsupportccctc@openccc.zendesk.com.

Why am I being asked for a Verification code?

The verification code is required as the second factor used in two-factor authentication (the password is something you know, the verification code is something that you obtain. This additional step helps to secure access to the data in the DW Report Server.

How do I generate a new Verification code each time I login?

New verification codes are generated using your Authenticator software from your desktop or mobile device. After entering the required information on the login page and continuing to the Verification page, refer to your Authenticator software and find your six-digit, time-based verification code that aligns to your secure Data Warehouse Report Server account and paste it into the Verification code input field.

Why is my Verification code timing out?

The verification code is a time-sensitive code designed to time out after 60 seconds. Your authenticator app will show how long it is until the code expires so that you can enter and submit the code in the window that it exists for.

About the Data Warehouse Report Server

What is the Data Warehouse Report Server?

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

  • The 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 and reports and analytics that end-users need.

What’s the difference between CCC Data Warehouse and CCC Data Warehouse Report Server?

The CCC Data Warehouse is a structured database, the Data Warehouse Report Center is an analytics software package connected to the database providing an interface to query and extract these data.

What’s the difference between JasperReports and the Data Warehouse Report Server?

The Data Warehouse Report Server (v.1.4.1) is a CCC-branded version of TIBCO JasperReports (v.6.4.4) with role-based access to integrated CCC Data for authorized CCC researchers using multi-factor authentication (MFA).

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.

What is two-factor authentication?

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

What data is available in the Data Warehouse Report Server?

In the August 2020 release (v.1.4.1) the following data sets will be available in the Data Warehouse Report Server:

  • CCCApply Standard & Noncredit Applications

  • CCCApply LGBTQ Data (AB 620)

  • CCCApply International Application

  • CC Promise Grant Application

  • Multiple Measures Placement Service (MMPS)
    We will notify users of the DW Report Center of new data sources to be made available as these releases are scheduled.

What data am I allowed to access with my user account?

You are able to access all available data sources segmented to your college or district by MIS code.

Will additional data sets be added to the Data Warehouse Report Server?

Yes. We will notify you as additional data sets are scheduled to be added. These additional data sets will include, though not limited to, COCI, C-ID, MyPath, and Canvas data.

Are any ready-made reports available in the Data Warehouse Report Server?

The DW Report Server includes the LGBTQ report developed in support of AB620.

Who is authorized to use the Data Warehouse Report Server?

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 with the information below.

Is there a release roadmap for the Data Warehouse Report Server?

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

User Account Setup

Where can I find the Data Warehouse Report Server User Guide?

The Data Warehouse Report Server - User Guide has been posted on the CCC Data Warehouse Public Documentation home page. This document will be updated as needed.

Where do I go to login to the Data Warehouse Report Server?

 

What is the “first-time user login” process?

How do I request access to the Data Warehouse Report Server?

How do I get my user account login credentials?

Authorized users of the CCC Data Warehouse Report Server are provided their account credentials and password during the implementation process between the user and the CCCTC Enabling Services implementation team. For more information, please contact your College Relationship Manager (CRM) at crms@ccctechcenter.org.

How do I find my “Organization (MIS Code)?

The Organization (MIS Code) is the number assigned to each college and district by the Management Information System Division of the California Community Colleges Chancellors Office. Each district and college has a unique 3-digit MIS code number identifying their college. This is the number that is used in the Organization (MIS Code) field on the Data Warehouse Report Server login process.

How do I find my User ID?

The User ID field, which appears on the Login page, is a text input field requiring the authorized user’s institutional email address (.edu).

How do I find my Password?

The password that is required for login is a unique code generated by the CCCTC Administrator and passed to the authorized user through a secure method during the implementation process. If you are a college or district IRPE and would like to inquire about authorized access to the Data Warehouse Report Server, please contact your College Relationship Manager (CRM) at crms@ccctechcenter.org for more information.

What do I do on the “Scan Your QR Code” page?

The “Scan QR Code” page only appears to a new authorized user during the “first-time user login” process (one time process) when authenticating and validating a new Data Warehouse Report Server User Account. See the Data Warehouse Report Server - User Guide for details.

How do I scan the QR code on my desktop computer?

One of the steps in the two-factor authentication process Data Warehouse Report Server authorized user “first-time login” process - which is a one-time process that aut that authorized users must cIn order for authorized users to complete the “first-time user login” process - which is a one-time process only - they

How do I scan the QR code on my mobile device?

Scanning the QR code during the “first-time user login” process depends on the Authenticator software you have installed on your mobile device.

How do I get the Verification code?

After scanning the QR code for the first time with your Authenticator software, you will see an entry for “JRS” with a six-digit code. 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 Verification code input field, then click “Login”.

 

Using the Report Server

How do I find the LGBTQ data for my college?

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

Is there a LGBTQ report template I can use?

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

How do I customize the LGBTQ report template?

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.

How do I schedule a report to run weekly or monthly?

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.

 

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.

 

 

Help & Support

How do I request help using the Data Warehouse Report Server?

If you/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.

Are there any training materials available for the Data Warehouse Report Server?

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

I can’t seem to access the Data Warehouse Report Server. How do I report an issue with the Report Server?

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