| 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?
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.
...
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?
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?
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 Documentationhome page. This document will be updated as needed.
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.