Part 1: Overview

The information provided in this document serves as a "Quick Start" guide for the CVC-/OEI Report within the CCC Data Warehouse Report Server (“DW Report Server”). With the CVC-/OEI Report you can:

• Query data exclusively for colleges participating in the CVC-/OEI Course Exchange program.

• Export report data in multiple formats, including CSV.

About the Data Warehouse Report Server

The DW Report Server is an easy-to-use report generator tool that pulls data from the CCC Data Warehouse.

...

User Authorization & Authentication

Access to the CVC-/OEI Report within the Data Warehouse Report Server requires an authorized user account with two-factor authentication to ensure the privacy and security of the Data Warehouse Report Server.

Requesting Access to the CVC

...

/OEI Report

Authorized users:

Support & 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 PST. Depending on the nature of the issue or comment, support engineers will respond within 24 hours to critical issues regarding production applications.

...

Part 2: The User Account Setup & Login Process

This part of the User Guide provides information about:

• The Report Server User Account

• The Account Creation & User Setup Process

• Receiving Your Secure Login Credentials

• Implementing the Authentication Software

• The First-Time User LogIn Process

• Verified User Login Process

TheCVC

...

/OEI College User Account

Access to the CVC-/OEI Report within the DW Report Server is designed with two-factor authentication (2FA) to secure and protect our college and systemwide student data. Two-Factor Authentication is a security system that authenticates a user’s identify by requiring two or more pieces of evidence (credentials + verification code) before granting access to a service or system.

User Types & Access Levels

Authorized access correspond directly to the user’s college or district 3-digit MIS Code, as shown in the table below.

Account Creation & Setup Process

The account creation and user setup process is a two-part workflow between a CCCTC system Administrator and the authorized user. Below is a breakdown of the two-part setup process for the Administrator and the User.

...

• The User engages with the Enabling Services implementation team and receives account credentials and user setup information

• The User installs a compatible authentication app on their desktop or mobile device

• The User completes the “first-time login” process (the one-time scan of the QR code with authenticator app happens and captures Verification code required for login)

• The User is automatically authenticated and authorized to login to the DW Report Server.

Receiving Your Secure Login Credentials

For security purposes, the User will receive their account credentials and password from the CCCTC Administrator in two separate emails to their institution email address (.edu).

...

Implementing the Authentication Software

Before the user can log in to the Report Server for the first time, they must have a compatible authentication app installed that implements Time-based One-Time Password TOTP functionality such as Google Authenticator, or Chrome Authenticator. There are many free, user-friendly Authenticator apps available at no cost that can be downloaded and installed quickly and easily onto your desktop and/or mobile device.

Chrome Authenticator for Desktop

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.

To Install the Chrome Authenticator:

...

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

Google Authenticator App for Mobile Device

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.

...

The First-Time LogIn Process

The first time a new user logs into the Data Warehouse Report Server they need to establish the connection between their account credentials, a shared secret key (QR Code) and the authentication softwarein order enable the multi-factor login authentication. This is a one time process that is completed in the steps below.

...

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

• The user has received their unique password and account credentials from the CCCTC Administrator

• The user has installed and configured a compatible authentication application on their desktop and/or mobile device

Step 1: Enter 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 URL(http://dw-reports.ccctechcenter.org/) and land on the Log In page.

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

...

Step 2: Scan the QR Code Page

The Scan the QR Code page is displayed once during the “first-time user login” 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.

...

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.

Step 3: Repeat Log In Page

After scanning and capturing the six-digit verification code in authenticator app, you have established the connection between the authenticator application and your secure Report Server User Account.

...

Step 4: Verification Code Page

After re-entering the account credentials a second time, the user is now presented with the Verification Code page to enter the six-digit verification code that was scanned and stored in the Authenticator app. .

1. Enter your six digit Verification Code

   1. Click on your Authenticator app and retrieve the time-limited verification code.

   2. Paste the code in the “Verification Code” field.

2. Click the “Login” button on the Verification Code page to complete the login process.

...

Verified User Login Process

The “first-time login” process is a one-time process. Once the new user has completed the first-time login process, they do not have to repeat steps 2 - 4 UNLESS they need to re-install their authentication software and generate a new QR code.

After the first time login and verification process, user login requires the user to enter their credentials and the verification code retrieved from the authenticator app.

...

Step 1: Log in Page

1. Navigate to the Report Server URL (http://dw-reports.ccctechcenter.org/) and land on the Log In page.

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

   1. Organization (MIS Code): Enter your 3-digit MIS Code.

   2. User ID: Enter your institutional email address in the User ID field (.edu, or org) (Required)

   3. Password: Enter your unique password.
      
      
      
      
      
      
      
      

...

Step 2: Verification Code Page

1. The User refers to their authenticator app to retrieve their new Verification code within 30 seconds of making the request (clicking on Login button on Log In screen).

2. Verification Code: The user enters the code from the Authenticator App into the Verification Code field.

3. Click the “Login” button on the Verification Code page to complete the login process and access the DW Report Server.

...

...

Part 3: Querying & Exporting Data Using the CVC

...

/OEI Report

The CVC-/OEI Report is a ready-to-use table report within the CCC Data Warehouse Report Server.

Working with the Report Server

The Home Page

The first thing that displays when you log in to the Report Server is the Home page.

...

The Library Page

The Library page offers a more focused view of the repository objects. It contains only the Ad Hoc views, reports, and dashboards that the user is authorized to view and work with.

...

All of these functions are available by right-clicking the item you want to work with and selecting an action from the context menu.

...

The Repository Page

The Repository is the server’s internal storage for folders, reports, analysis views, and related files. The repository is organized as a structure of folders containing public and private resources and templates., much like a file system.

...

Each CCC college organization has a district and college folder which can be used for saving ad hoc views and reports, and content resources.

...

Running the CVC

...

/OEI Report

When you run a report, it opens in the interactive Report Viewer. With the Viewer, you can personalize and refine the displayed report data. If the report has input controls, you run the report with one set of data and then another.

Use the following steps to access your reports once you are logged in to the Data Warehouse Report Server.

...

Example 2: Reports will built-in Filters will display an “Input Controls” dialog box when executing a report.

...

Understanding & Using Filters (Input Controls)

You can take the following actions in the Input Controls dialog box:

...

Note: Once you click a date in the calendar automatically closes.

...

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.

To create a relative date filter:

Following the instructions in Using Filters, create a filter based on a date field. The filter appears in the Filters panel.

...

Scheduling Reports

You can schedule a report to run at a specific date and time, including a recurring time frame (every Friday at 9 am. for example). The image below is an example of how you begin this process.

...