Versions Compared

Key

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

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

This guide is for the Data Warehouse Report Server (CCC Data 2.25.0) released to production on January 27August 16, 2023.

In This User Guide

...

Access to the DW Report Server is restricted to authorized users to ensure the privacy and security of the data within the CCC Data Warehouse. Users must request access using via one of the appropriate processes below , and upon approval will be granted an account based on their user type.

...

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

Contact your College Relationship Manager (CRM) from the CCCTC Enabling Services team to request authorized access or setup an approved account, today.

User Accounts

Access to the DWRS requires an authorized user account configured based on user type. There are two types of authorized user accounts:

  • SSO Users: Colleges and Districts using their institution’s IDP for single sign-on. The institution’s log in may include (CCCTC does not manage your institution’s two-factor authentication (2FA) , but this SSO mechanism is not managed by the CCCTC.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.

...

The process for account setup and log in will be different depending on user type, access level, and the mechanism used to authenticate. Working with an Implementation & Configuration Engineer (ICE) from the CCCTC Enabling Services team to set up and configure your account, college & district users (SSO Users) will be are provided a custom URL configured to your institution’s institution MIS code and internal IdP link. Non-SSO Users will be directed to the DWRS directly URL to log in and complete additional setup & verification tasks steps to facilitate authentication.

Below is an explanation of the setup process followed by summaries of the log in process for each of the two authentication methods.

Pre-requisites

Prerequisites for All Users

Before a user can log into in to the DWRS the following conditions must be met:

  1. You - the The authorized user - have has followed the Getting Started tips above and have has coordinated with CCCTC Enabling Services to begin the account creation setup and configuration process based on your user type and access level.

  2. CCCTC Enabling Services has created added and configured your account with the appropriate roles and attributes, and has sent your account credentials via secure method.Your account has been configured with the appropriate role(s), attributes, and your college or district’s IDP information (

  3. for college and district SSO Users ONLY).SSO Users Only: You have bookmarked your unique college or district DWRS URL bookmarked and you know your institution’s IdP single sign-on credentials provided (managed locally by your college or district IT department).

  4. Non-SSO Users Only: You have received your account credentials and temporary password from a CCCTC Enabling Services Administrator; youhave , installed an the authentication software app, and have completed theFirst-Time User Log Inprocess required to facilitate initiate two-factor authentication.

...

SSO Users: Account Setup & Log In Process

Colleges College & DistrictsDistrict Users

  1. The User coordinates with the CCCTC Enabling Services

...

  1. team to ensure their account is configured with the required roles, attributes, and

...

  1. IDP

...

  1. link.

  2. The User is

...

  1. provided the appropriate DWRS URL for their IDP and logs in.

  2. The User is authenticated locally through their

...

  1. institution’s IDP (SSO) and

...

  1. logs in to the DWRS.

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

College & district user credentials are set by their institution IdP for single sign-on (SSO). These users should know their unique credentials or should contact their institution’s IT department to change or update themusers should contact their institution’s IT team for information on their local SSO credentials. These credentials are not managed by the CCCTC.

Non-SSO Users: Account Setup & Log In Process

All Other Users

  1. The User coordinates with the CCCTC Enabling Services

...

  1. team

...

  1. to get their temporary password and first-time

...

  1. log in information via secure method (i.e., Privnote).

  2. The User downloads and installs compatible authentication software on their desktop or mobile device.

  3. The User completes the “First-time User Log In” process, which enables entry of account credentials, one-time QR code verification, and authentication to the DWRS.

  4. Optional: After logging in, the User may update their temporary password using the Forgot Password? link to reset their password.

Receiving Your Secure Account Credentials

For security purposes, all non-SSO users will receive your account credentials and a temporary password in one or two separate emails from an CCCTC Enabling Services Administrator. The email(s) will include a link to a secure Privnote message , sent to the user’s institution email address (.edu).

Panel
panelIconIdatlassian-warning
panelIcon:warning:
bgColor#F4F5F7

Note: The password will not be passed to the authorized user until they have started initiated the implementation process with the CCCTC Enabling Services teamfor added security.

...

The First-Time User Log In Process

For Non-SSO Users Only: The first time a new non-SSO user attempts to log in to the DWRS they must establish the connection between their user account credentials, a shared secret key (QR Code), and the authentication software to enable the two-factor (2FA) log in authentication.

Pre-requisitesPrerequisites:

  • The User has the Data Warehouse Report Server DWRS direct access URL: (https://dw-reports.ccctechcenterccctechcenter.org/jasperserver-pro/login.html).

  • The User has received their account credentials from the CCCTC Implementation & Configuration a CCCTC Enabling Services Administrator.

  • The User has installed and configured a compatible authentication software app on their desktop and/or mobile device.

Expand
titleExpand here to see the First-Time User Log In steps (one-time process).
Note

Non-SSO Users Only: Complete this one-time process using the steps below.

Step 1: Enter Your Account Credentials on the Log In Pages

  1. Ensure you have one of the compatible authenticator apps installed on your desktop or mobile device.

  2. Navigate to the Data Warehouse Report Server URL for non-SSO users (https://dw-reports.ccctechcenter.org/jasperserver-pro/login.html); land on the log in page.

  3. Enter your Username or Email Address (institutional email address) in the Username or email input field (.edu or .org is required) on the main “Sign in to your account” screen. Click “Sign In” to proceed to the nextscreen.

  4. Enter your the temporary Password provided to you by the CCCTC Enabling Services Administrator (sent separately via Privnote). Click the “Sign in” button to continue to the QR Code Scan screen.

Screen shot of the Data Warehouse Report Server Sign In Email screen.

Screen shot of the Data Warehouse Report Server Sign In Password screen.

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

The temporary password is generated by the a CCCTC Enabling Services Administrator during the account creation process. You can change this password at any time by using the “Forgot Password?” link.

Step 2: Scan the QR Code Page

The Scan the QR Code page is displayed once during the “first-time user log in” process. The user must have the authentication software installed on their desktop or mobile device in order to scan the QR code that appears on the page. The code is captured by the authenticator app which establishes the connection between the account (shared secret key hidden in the barcode) and the authenticator app to complete the initial two-factor authentication process.

  1. With your Authenticator App installed, scan the QR code that appears in the center of the page.

    1. Scanning the QR Code with Chrome Authenticator (from desktop).

    2. Scanning the QR Code with Google Authenticator(usinga mobile device).

  2. As the authenticator scans the barcode (QR Code), a six-digit verification code will appear/register in your authenticator app.

  3. As soon as you see the six-digit code appear in your authenticator app, copy the code and then click “Submit” to go to the next page.

Panel
panelIconIdatlassian-warning
panelIcon:warning:
bgColor#F4F5F7

NOTE: This step requires the user to use theirauthentication app previously installed on their desktop or mobile device to scan the onscreen barcode. The “secret” key identified by the barcode will add the required attribute to the User’s account.

Using Chrome Authenticator to Scan the QR Code

  1. Once the Chrome Authenticator app has been installed, a shortcut will appear in your Extensions toolbar in your browser.

  2. Click the Authenticator icon in your Extensions toolbar to open the tool.

  3. Click the scan icon and move your mouse over the QR barcode in the center of the page.

  4. Click + hold the mouse to drag the scan functional across the bar code.

  5. The secret key hidden within the barcode will register as a six digit code in the Authenticator registered to your Report Server account.

Using Google Authenticator to Scan the QR Code

  1. Once the Google Authenticator app has been installed on your mobile device, an icon will appear on your phone wall or homepage.

  2. Click to open the Google Authenticator app

  3. Point the camera on your mobile device at the barcode on the screen and snap a picture.

  4. The secret key hidden within the barcode will register as a six digit code in the GA app registered to your DW Report Server account.

Panel
panelIconIdatlassian-check_mark
panelIcon:check_mark:
bgColor#F4F5F7

Tip: After scanning the QR code and confirming the verification code is captured by the authentication software, snap a screen shot of the code and store in a secure place. For security purposes, don’t store the verification code with the URL or other credentials to the DWRS.

...

For Non-SSO Users Only: After the user completes the one-time “First-Time User Log In” process, the user is “verified” and will not have to repeat the Scan the QR Code Page stepagain UNLESS they need to re-install their authentication software and/or generate a new QR code. For all subsequent s, the verified user needs only to enter their account credentials and the verification code retrieved from their authenticator app.

...

Step 1: Log in Page Enter Username or Email

  1. Navigate to the Data Warehouse Report Server URL (https://dw-reports.ccctechcenter.org/jasperserver-pro/login.html) and land on the Log In page.

  2. Enter your user account credentials and password in the input fields.

    User ID: Enter your institutional

    username or institution’s email address in the

    User ID

    input field

    (

    .

    edu, or org) (Required)

  3. Password: Enter your unique password.

  4. Click the “Sign In” button.

Panel
:
panelIconIdatlassian-lightcheck_bulb_onmark
panelIcon:lightcheck_bulb_onmark:panelIconText
bgColor#F4F5F7

Tip: Your Username is your institution or organization email address used during the initial account setup with the CCCTC Enabling Services team.

Screen shot of the Data Warehouse Report Server Sign In Password screen.Image Added

Step 2: Enter Password

  1. Enter your password in the Password input field or click the Forgot Password? link to reset your password.

  2. Click the “Sign In” button.

Panel
panelIconIdatlassian-light_bulb_on
panelIcon:light_bulb_on:
panelIconText:light_bulb_on:
bgColor#F4F5F7

Reminder: Click the Forgot Password? link on the Log In page to recover your account password or to change your password at any time.

Step 23: Enter Verification Code Page

...

  1. Immediately upon landing on the “One-time code” screen, copy the verification code from your Authenticator app within 30 seconds of making the request (clicking on Sign In button on Log In screenafter entering password).

  2. Verification Code: Enter the code from the authenticator app into verification code in to the “One-time code” field.

  3. Click the “Sign in” button to complete the log in process and access the DWRS.

Panel
panelIconIdatlassian-check_mark
panelIcon:check_mark:
bgColor#F4F5F7

Best Practice: To save time retrieving your verification code, consider labelling the DWRS entry in your Authenticator tool, especially if you are using the tool for more than one application.

Password Reset Process

To change or update your user account password:

  1. Navigate to the Data Warehouse Report Server sign-in page at https://dw-reports.ccctechcenter.org/jasperserver-pro/login.html.

  2. Click on the “Forgot Forgot Password?” link that sits below the “Sign in to your account” input fields.

...

...

  1. which is available on every screen.

...

  1. Enter your email address that was used to create your account

...

  1. .

  2. Click Submit.

...

A confirmation message appears on the screen directing you to retrieve an email.

...

  1. On the Home page, click Create in the Reports block. The Create Report wizard opens.

  2. Select the Ad Hoc view you want to use as the basis for your report.

  3. 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.

  4. Click OK. If asked, enter the input controls needed. See Using Input Controls.

...

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

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:

  • Keyword indicates the time span you want to use. Options include: DAY, WEEK, MONTH, QUARTER, SEMI, and YEAR. An option used by itself (without +/-<Number>) gives the current value for that option.

  • or - indicates whether the time span occurs before or after the chosen date.

  • Number indicates the number of the above-mentioned time spans you want to include in the filter.

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.

...