Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

CCC Data Warehouse Report Server v7.8 Last Update: June 2022

...

  • College and District Institutional Researchers: 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 Manager (CRM) with the information below.

  • 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
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

Process for IRPE 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.

...

Getting Started

Establishing an authorized DWRS user account is a two-part workflow between a CCCTC Administrator and the approved user. An Enabling Services Implementation Configuration Engineer (ICE) will create and configure the account in our internal system and then work with the user to complete the final steps and login, depending on the user type. This section of the document outlines the roles and responsibilities - and setup tasks - for the CCCTC Administrator and the approved DWRS user.

...

User Types & 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
panelIconIdatlassian-info
panelIcon:info:
bgColor#FFFFFF

College & District SSO Users - : See Appendix A: Data Warehouse Report Server URLsfor your custom IdP URLsURL.

Set Up & Log In Processes

...

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

  2. The account has been configured with the appropriate roles, attributes, and - for SSO Users only - their institution’s IDP link.

  3. SSO Users have received their unique college or district URL, configured to their IDP, and know their single sign-on credentials provided to them by their college or district’s IT department.

  4. Non-SSO Users have received their account credentials and temporary password from CCCTC Administrator, have installed the authentication app software, and have completed theFirst-Time User Log Inprocess (setup and verification tasks) required to facilitate two-factor authentication at the generic DWRS URL.

...

SSO Users: Account Setup & Log In Process

Colleges & Districts

  • The User coordinates with the Enabling Services implementation team and receives acknowledgment that their account has been created with the appropriate roles and attributes, and the IDP has been linked.

  • The User is directed to the appropriate URL for their IDP and logs in.

  • The User is authenticated through their institution IDP (SSO) and is logged in to the DWRS.

...

Non-SSO Users: Account Setup & Log In Process

All Other Users

  • The User coordinates with the Enabling Servicesimplementation team and receives account credentials and user setup information via secure method (i.e., Privnote).

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

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

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

...

Authenticator for Mac and Windows Chrome browsers is available free from the Chrome Web Store. This app installs very quickly to your desktop (recommended) as well as your phone, and includes a lot of great features that promote security and usability. NOTE: The entire download and install process takes less than one minute. You may need local IT authorization and assistance to install it if policy requires this.

Expand
titleExpand here to see instructions for downloading and installing the Chrome Authenticator app.

To Install the Chrome Authenticator:

  1. Navigate to the Chrome Web Store and search for Authenticator by authenicator.cc

  2. Click on “Add to Chrome” button to initiate the download and follow very simple instructions to install.

  3. When the Authenticator app has been installed, a shortcut will appear in your Extensions toolbar in your browser.

Note

WARNING: If you have already installed Chrome Authenticator (Authenticator.cc) don’t re-install this application as it will overwrite you previous download of this same application.

Panel
panelIconIdatlassian-check_mark
panelIcon:check_mark:
bgColor#F4F5F7

NEXT: Start the “First-Time User Log In” process below to initiate the authentication process and login.

...

Another user-friendly option, especially for users who want to use their mobile device for authentication, is the Google Authenticator; a free app available from the Google Play Store.

Expand
titleExpand here to see instructions for downloading and installing the Google Authenticator App.

Google Authenticator is compatible with multiple different mobile devices, operating systems, and browsers. The process for downloading and installing can be found here.

Panel
panelIconIdatlassian-check_mark
panelIcon:check_mark:
bgColor#F4F5F7

NEXT: Start the “First-Time User Log In” process below to initiate the authentication process and login.

...

  • The User has the Data Warehouse Report Server URL (http://dw-reports.ccctechcenter.org/).

  • The User has received their account credentials and temporary password from the CCCTC 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 Page

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

  2. Navigate to theData Warehouse Report Server URLlog in page.

  3. Enter the account credentials provided to you into the following fields:

  • User ID: Enter your institutional email address in the User ID field (.edu or .org is required).

  • Password: Enter the temporary password provided to you by the CCCTC Administrator (sent separately via Privnote).
    Click the “Sign in” button to continue to the QR Code Scan page.

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

The temporary password is generated by the CCCTC 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.

...

To run a report, click the name of a report in the repository. For example, click DW LGBTQ Report. The report appears in the Report Viewer.

...

  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.

You can now begin working with your report.

...

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.

...