| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
This guide is for the Data Warehouse Report Server (CCC Data 2.5.0) released to production on August 16, 2023. |
...
The information provided in this document serves as a " Quick Start " guide for users of the CCC Data Warehouse Report Server (“DW Report Server”, “Report Server”, “DWRS”), including:
...
The DW Report Server is a secure, user-friendly reporting tool that creates pixel-perfect reports, charts & and dashboards using secure CCC Data Warehouse data.
The CCC Data Warehouse is a structured source of master primary data that can be used to generate the data marts and reports and analytics that end-users need.
The DW Report Server is powered by JasperReports, a Java-based open-source reporting tool. JasperReports, connected to the CCC Data Warehouse, allows for advanced reporting usage and provides extensive help that you can access from the Help link.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
About TIBCO JasperReports Server |
User Authorization
...
and Authentication
Access to the DW Report Serveris restricted to authorized users to ensure the privacy and security of the data within the CCC Data Warehouse. Users must request access via one of the appropriate processes below and upon approval will be granted an account based on their user type.
...
College and District Institutional Researchers: An upon confirmation from their college or district Vice President, an identified lead IRPE Researcher at each college or district will be established as the authorized user and “gatekeeper” for their institution (organized by MIS Code) upon confirmation from their college or district Vice President. These “gatekeepers” can then request access for additional researchers at their institution by submitting an email request to ES Support Services or by contacting their College Relationship Experience Manager (CRM) with the information below.this information:
User’s Name
User’s email address (.edu)
Chancellor's Office & Other External Stakeholders: All requests for access to the Data Warehouse Report Server from the CCC Chancellor's Office or other external stakeholder organization are to be directed to the CCC Data Warehouse Product Manager (Mark Cohenmcohen@ccctechcenter.org)who must obtain approval from the Vice Chancellor for Digital Innovation & Infrastructure at the CCC Chancellor’s Office.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Process for IRPE Gatekeepers to Request Additional Users |
...
Support and FAQs
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 PSTPT. Depending on the nature of the issue or comment, support engineers will respond within 24 hours to critical issues regarding production applications.
...
Part 2: User Accounts
...
and Access
This section includes:
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Contact your College Relationship Manager (CRM) from the CCCTC Enabling Services team to request authorized access or setup set up an approved account, today. |
User Accounts
There are two types of authorized user accounts:
SSO Users: Colleges and Districts using their institution’s IDP for single sign-on. ( CCCTC does not manage your institution’s two-factor authentication (2FA) mechanism, if implemented.)
Non-SSO Users: CCCCO, CVCOEI, and other authorized external users will authenticate directly to the DWRS using 2FA to secure and protect our systemwide student data.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Two-Factor Authentication (2FA) is a security process that authenticates a user’s identity by requiring two or more pieces of evidence (credentials + verification code) before granting access to a service or system. |
User Types
...
and Access Levels
User Type | Authentication | Authorized Access Level | |
College User | SSO User | SSO access via college/district IdP | Single college access to available data sets based on College MIS Code |
District User | SSO User | SSO access via college/district IdP | Multi-college access to available data sets based on District MIS Code |
Chancellor's Office User | Non-SSO User | Direct access (non-IdP) via two-factor authentication (2FA) | Access to all data sets across all colleges |
CVCOEI User | Non-SSO User | Direct access (non-IdP) via two-factor authentication (2FA) | Access to CVCOEI report but no actual data (can see tables and columns in AdHoc view, but no data populates) |
CCCTC Administrator | Non-SSO User | Direct access (non-IdP) via two-factor authentication (2FA) | Access to the internal system administration console to facilitate account creation & configuration. |
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
College & District SSO Users: See Appendix A: Data Warehouse Report Server URLsfor your custom IdP URL. |
Set Up
...
and Login Processes
The process for account setup and log in login will be different depending on user type, access level, and the mechanism used to authenticate. Working with the CCCTC Enabling Services team to set up and configure your account, college & district users (SSO Users) are provided a custom URL configured to your institution MIS code and internal IdP link. Non-SSO Users will be directed to the DWRS URL to complete additional setup & verification steps to facilitate authentication.
...
The authorized user has followed the Getting Started tips above and has coordinated with CCCTC Enabling Services to begin the account setup and configuration process based on user type and access level.
Non-SSO Users Only: CCCTC Enabling Services has added and configured your account with the appropriate roles and attributes, and has sent your account credentials via secure method.
SSO Users Only: You you have bookmarked your unique college or district DWRS URL and know your institution’s IdP single sign-on credentials (managed locally by your college or district IT department).
Non-SSO Users Only: You have received your temporary password from a CCCTC Enabling Services Administrator, installed the authentication software, and have completed the “First-Time User Log In” process required to initiate two-factor authentication.
...
The User coordinates with the CCCTC Enabling Services team to ensure their account is configured with the required roles, attributes, and IDP an IdP link.
The User is provided the appropriate DWRS URL for their IDPIdP and logs in.
The User is authenticated locally through their institution’s IDP IdP (SSO) and logs in to the DWRS.
...
On the Home page, click Create in the Reports block. The Create Report wizard opens.
Select the Ad Hoc view you want to use as the basis for your report.
Select a report template. To use a template other than the default, select Custom Report Template, click Browse and select the desired template. See Report Templates for more information.
Click OK. If asked, enter the input controls needed. See Using Input Controls.
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Creating Filters with Relative Dates You can filter information in your view based on a date range relative to the current system date. You can accomplish this using date-based filters, and entering a text expression describing the relative date or date span you want to display, using the format <Keyword>+/-<Number> where:
For example, if you want to see all of the CC Promise Grant Applications submitted during the prior week, your expression would be: WEEK-1. |
...