Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

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?

Why isn’t my user DW Pilot account (login credentials) working anymore? Did something change?

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

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 ES 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.orgwho 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?

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?

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

Why is my Verification code timing out?

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?

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 multi-factor authentication?

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)

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

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

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

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?

User Account Setup

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

Where do I find my user account login credentials?

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

How do I find my User ID?

How do I find my Password?

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

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

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

How do I get the Verification code?

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

What do I need to setup for “first-time user login”?

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

Using the Report Server

How do I find the LGBTQ data for my college?

Is there a LGBTQ report template I can use?

How do I customize the LGBTQ report template?

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

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

What fields are included on the CCCApply LGBTQ Report?

How do I change the date filter on a public report?

How do I build an ad hoc report?

How do I copy a report?

How do I schedule a report?

How do I filter the data in a report?

Why am I getting an error message saying that my report is exceeding 25,000 rows?

How do I filter my data by a specific date range?

Help & Support

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

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

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