Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Welcome! The FAQs below pertain to Data Warehouse Report Server for CCC Data v.2.2.0, released to production on January 27, 2023. |
...
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-facing 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 v2.2.0, the DW Report Server is now secured through single sign-on (SSO). To do this we needed to retire account access to the DW Report Server (and LGBTQ Report), migrate all existing accounts over and enable all new user accounts be created in our new secure system - which means your old password will no longer work.
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.
I’m getting an error page when I try to log in to the Data Warehouse Report Server. Did the URLchange?
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 using 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 re-validate their existing account credentials.
How do I request 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 stakeholders, must be directed to Mark Cohen, Product Manager, CCC Data,mcohen@ccctechcenter.orgwho will obtain approval from the appropriate CCCCO Vice Chancellor.
I'm no longer working as an IRPE for the California Community Colleges. Whom should I notify to remove my user access?
Please notify the research lead at your college or contact CCCTC Enabling Services directly at ES Support Services.
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.
...
Do I need to enter a password to access the Data Warehouse Report Server?
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 Log In 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 & Districts): Your password is now the password managed by the 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.
Why am I being asked for a verification code?
For Non-SSO Users Only: A verification code is required as the second factor used in two-factor authentication for all Nonnon-SSO Users users only (the password is something you know, and 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?
For Non-SSO Users Only: A new verification code is generated in your the Authenticator app software you installed on your desktop or mobile device during the implementation process. After entering the required information on the Log In page and continuing your email and password credentials and continue to the “One-time code” screen, refer to open your Authenticator app to find and copy the six-digit , time-based verification code that aligns to your secure is generated for the Data Warehouse Report Serveraccount and enter it into . Enter the code in the “One-time code” input fieldfield before the code expires (30 seconds).
Why is my verification code timing out?
The “one-time” For Non-SSO Users Only: 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 “One-time code” input field. About the Data Warehouse Report Server30 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.
About the Data Warehouse Report Server
What is the Data Warehouse Report Server?
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.
What’s the difference between the CCC Data Warehouse and the Data Warehouse Report Server?
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.
What’s the difference between JasperReports and the Data Warehouse Report Server?
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.
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?
The following data sets are currently available in the Data Warehouse Report Server (as of CCC Data v.2.2.0):
...
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Users are notified of all new data sources when they are scheduled for release to production. |
What data am I allowed to access with my user account?
Authorized DWRS user types and access levels are defined in the Data Warehouse Report Server User Guide.
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.
Is there a development 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 is stored in the CCC Data Warehouse Public Documentationspace. This guide is a living document is updated as needed.
How do I get to the Data Warehouse Report Server?
SSO Users (college & district users) are provided a custom URL based on the institution’s IDP for single sign-on. College & district URLs can be located in Appendix A of the Data Warehouse Report Server User Guide.
Non-SSO Users (all other authorized users) will continue to use the DWRS URL: https://dw-reports.ccctechcenter.org/jasperserver-pro/login.html
What is the “first-time user log in” process?
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 Log in process to gain access the DWRS.
How do I get my user account login credentials?
SSO Users: College & 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 & 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.
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 code is added as an attribute by a CCCTC Administrator and will show in JasperReports after initial successful login.
How do I find my Username or Email?
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).
How do I find my Password?
Non-SSO Users: Chancellor’s Office & other external users are provided a temporary password during the implementation process. See the Non-SSO Users: Account Setup & Log In Process in the Data Warehouse Report Server User Guide.
College & 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.
What do I do on the “Scan Your QR Code” page?
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 Guidefor details.
How do I scan the QR code on my desktop computer?
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 Guidefor details.
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. See the Data Warehouse Report Server User Guidefor details.
How do I get the Verification code?
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.
...
Using the Report Server & the LGBTQ Report
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 Guideor 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 Guideprovides 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.