| Info |
|---|
The CVC/OEI Enrollment Report is a report in the CCC Data Warehouse Report Server (DWRS). |
...
Access to the CVC/OEI Enrollment Report in the DWRSrequires 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
...
The first time an approved CVC/OEI user logs into in to 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 using the steps below.The prerequisites for
initiating the Prerequisites
To prepare for your first-time login process, you must:
The user has Have the Data Warehouse Report Server URL (http://dw-reports.ccctechcenter.org/)
The user has received their Have received your account credentials and unique password and account credentials from the CCCTC Administrator
The user has Have installed and configured a compatible authentication application tool on their your desktop and/or mobile device
Step 1: Enter Account Credentials on the Log In Page
Ensure you have one of the compatible authenticator apps installed on your desktop or mobile device.
Navigate to theData Warehouse Report Server URL(http://dw-reports.ccctechcenter.org/) and land on the Log In page.
Enter the account credentials provided to you into the following fields:
Organization (MIS Code): Enter your 3-digit MIS Code“cvcoei” code here.
User ID: Enter your institutional email address in the User ID field (.edu or .org is required).
Password: Enter the unique password provided to you by the Administrator (sent separately via Privnotesecure process). This password is generated by the system Administrator during the account creation process. This
| Note |
|---|
Note: The unique password cannot be changed or reset by the user. |
Complete the Log In page by clicking the “Login” Button: After entering your user credentials, click the “Login” button to continue to the QR Code Scan page.
...
| Note |
|---|
Forgot Your Password? The unique password configured provided by the Administrator for the user account CCCTC cannot be changed or reset by the user. If you’ve forgotten your account password - , or if your account has been compromised and you need a replacement password, please contact ES Staff the Enabling Services Support team to request assistance at staffsupportccctc@openccc.zendesk.com. |
Step 2: Scan the QR Code Page
The Scan the QR Codepage is displayed once during the “first-time user login” time” 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.
With your Authenticator App installed, scan the QR code that appears in the center of the page.
Scanning the QR Code with Chrome Authenticator (from desktop).
Scanning the QR Code with Google Authenticator(usinga mobile device).
As the authenticator scans the barcode (QR Code), a six-digit verification code will appear/register in your authenticator app.
As soon as you see the six-digit code appear in your authenticator app, copy the code and then click “Login” to go to the next page.
Click the “Login” button to return to the Log In Page.
...
NOTE: This step requires the user you to use theirauthentication app - previously installed on their theauthentication software on your 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
Once the Chrome Authenticator app has been installed, a shortcut will appear in your Extensions toolbar in your browser.
Click the Authenticator icon in your Extensions toolbar to open the tool.
Click the scan icon and move your mouse over the QR barcode in the center of the page.
Click + hold the mouse to drag the scan functional across the bar code.
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
Once the Google Authenticator app has been installed on your mobile device, an icon will appear on your phone wall or homepage.
Click to open the Google Authenticator app
Point the camera on your mobile device at the barcode on the screen and snap a picture.
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.
| Tip |
|---|
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. |
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.
...
| Warning |
|---|
Validation Error Note: A validation error message will display to all users when they are completing the first-time user login” process. This system message is indicating that the user attempted to login without entering a verification code. As you know, you haven’t been asked for a verification code yet (that is coming in Step 4). Please disregard this error message and continue with the login process. |
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. .
Enter your six digit Verification Code.
Click on your Authenticator app and retrieve the time-limited verification code.
Paste the code in the “Verification Code” field.
Click the “Login” button on the Verification Code page to complete the login process.
...
Verified User Login Process
...
| Tip |
|---|
Reminder: The “first-time login” process is a one-time process intended to set up the two-factor authentication for your account. |
...
The Verified User Log In 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
Navigate to the Report Server URL (http://dw-reports.ccctechcenter.org/) and land on the Log In page.
Enter your account credentials and password in the input fields.
Organization (MIS Code): Enter your 3-digit MIS Code.
User ID: Enter your institutional email address in the User ID field (.edu, or org) (Required)
Password: Enter your unique password.
...
...
Step 2: Verification Code Page
The User refers to their Open your authenticator app to retrieve their new your Verification code within 30 seconds of making the request (clicking on clicking on the Login button on the Log In screen)page.
Verification Code: The user enters Enter the code from the Authenticator App authenticator app into the Verification Code field.
Click the “Login” buttonon the Verification Code page to complete the login process and access the DW Report Server.
...
| Note |
|---|
WARNING: Your unique Password is generated by the CCCTC Administrator at the time of account creation. The password cannot be changed or reset by the user. To get a new password, please contact ES Support Services. |
...
Part 3:
...
Using the CVC/OEI Report
...
| Info |
|---|
The following section provides authorized CVC/OEI |
...
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 Home page displays the following items
...
Report Server Home Page Sections
...
Allows you to:
...
Header bar Menu Items
...
click the Home icon from anywhere in the application to return to the Home Screen
click the Library link to view all available reports
click the View drop-down list to view Search Results, report Repositories, Schedules for scheduled report jobs, system Messages, or UI Samples for report design
click the Manage drop-down list is for managing Report Server access via organization, users, roles, and server settings; this option may only be available to CCC Tech Center staff
click the Create drop-down list to select short cuts to creating the items that also display in the Core Workflows section
On the right side of the header bar, you can:
...
2. Getting Started Column
...
quickly access the most frequently used features in the server
view and click items in the Recently Viewed Items and Popular Resources in the left navigation section
...
3. Core Workflow Icons
...
link to tutorial videos for each workflow
click a Create link for each workflow to create a new item within that workflow
click a View list link that displays all the already-created items in that workflow
...
4. Help
...
click the Help link to display JasperReports online help contents.
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.
| Note |
|---|
IMPORTANT: There is a 20K row limit on all reports that are run. When building a Table report, ensure there is one or more filters configured to limit the report data to display under 20,000 rows. |
Use the following steps to access your reports once you are logged in to the Data Warehouse Report Server.
Click View → Repository to display the repository Folders in a navigation panel on the left side of the screen.
From the navigation panel, click the Public folder → Data Warehouse folder → DW Reports folder to display the available reports for the Data Warehouse.
Click a linked report Name to run the report. Some reports will display results automatically while others may prompt you for parameters to refine the report results first via an Input Controls dialog box.
Example 1: The Apply DW Test High School Grade Report (takes no inputs and runs automatically). NOTE: The screen shot below references a previous version of the DWRS, but the table report shown displays the same when run.
...
After the report runs with input values, the Input Controls dialog box continues to display, which allows you to change the inputs, if needed. Use the table below to decide what action to take in the Input Controls dialog box.
...
Click this button in the Input Controls dialog box...
...
To...
...
Apply
...
run the report but leave the Input Controls dialog box open
...
OK
...
run the report and auto-close the Input Controls dialog box
...
Reset
...
set the field values back to their default after you've edited them; the
Input Controls dialog box remains open
...
Cancel
...
close the Input Controls dialog box; click View → Repository to return to the list of data warehouse reports
...
Save
...
to display the Save Values dialog box to save a specific value setting so you can use it easily the next time you run the report The next time you run the report, a drop-down lists displays in the upper left corner so you can select your saved value(s).
You can save the report or Export the report in a variety of file formats, such as PDF, Excel, CSV, DOCX, RTF, XLS, and more.
...
Click the...
...
To...
...
Save icon and select Save
...
save the report to the default DW Reports folder
...
Save icon and select Save As
...
display the Save As dialog box where you can select a different folder to save your report:
...
Export icon
...
select an export format that auto-downloads to your computer's hard drive default download location
After running and/or exporting a report, click View → Repository to return to the Repository screen to view the list of college and public reports.
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.
...
When you right-click a report Name, a pop-up menu displays and you can click the Schedule... option to open a Scheduled Jobs window that allows you to configure your scheduled report.
...
users with basic information on querying & exporting data using the CVC/OEI Enrollment Report. |
About the CVC/OEI Report
Querying Data
Log in to the DWRS using your CVC/OEI user account.
From the homepage, select the Library menu.
Select the Full Application by CCCID and MIS Code report.
...
| Note |
|---|
Authorized CVC/OEI users are only permitted access to the special report. |
4. Enter values in the Input Controls fields and press OK.
CCCID = Enter the CCCID for the student data being queried.
MIS Code = Enter the MIS code of the college associated with the student data being queried.
...
Note: Due to the uniqueness in how this report is set up, it is not possible for an account to have access to this report, and any other report (or research access) in the DWRS. If an individual requires access to both the research view of the DWRS and the CVC/OEI report, they will require two separate accounts (with unique email addresses).
Inputs & Outputs
The report
5. Once the report is generated, locate and click on the Export menu icon in the Report Viewer toolbar.
Select CSV from the Export menu options and click OK.
...
This will export the report data to a CSV file saved to the user’s computer desktop or Downloads folder. In CSV format, the file is suitable for use with MS Excel.
Report Server Home Page Sections | Allows you to: |
|
|
2. Getting Started Column |
|
3. Core Workflow Icons |
|
4. Help | click the Help link to display JasperReports online help contents. |
...
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.
| Note |
|---|
IMPORTANT: There is a 20K row limit on all reports that are run. When building a Table report, ensure there is one or more filters configured to limit the report data to display under 20,000 rows. |
Use the following steps to access your reports once you are logged in to the Data Warehouse Report Server.
Click View → Repository to display the repository Folders in a navigation panel on the left side of the screen.
From the navigation panel, click the Public folder → Data Warehouse folder → DW Reports folder to display the available reports for the Data Warehouse.
Click a linked report Name to run the report. Some reports will display results automatically while others may prompt you for parameters to refine the report results first via an Input Controls dialog box.
Example 1: The Apply DW Test High School Grade Report (takes no inputs and runs automatically). NOTE: The screen shot below references a previous version of the DWRS, but the table report shown displays the same when run.
Example 2: Reports will built-in Filters will display an “Input Controls” dialog box when executing a report.
After the report runs with input values, the Input Controls dialog box continues to display, which allows you to change the inputs, if needed. Use the table below to decide what action to take in the Input Controls dialog box.
Click this button in the Input Controls dialog box... | To... |
Apply | run the report but leave the Input Controls dialog box open |
OK | run the report and auto-close the Input Controls dialog box |
Reset | set the field values back to their default after you've edited them; the |
Cancel | close the Input Controls dialog box; click View → Repository to return to the list of data warehouse reports |
Save | to display the Save Values dialog box to save a specific value setting so you can use it easily the next time you run the report The next time you run the report, a drop-down lists displays in the upper left corner so you can select your saved value(s). |
You can save the report or Export the report in a variety of file formats, such as PDF, Excel, CSV, DOCX, RTF, XLS, and more.
...
Click the... | To... |
Save icon and select Save | save the report to the default DW Reports folder |
Save icon and select Save As |  display the Save As dialog box where you can select a different folder to save your report: |
Export icon | select an export format that auto-downloads to your computer's hard drive default download location |
After running and/or exporting a report, click View → Repository to return to the Repository screen to view the list of college and public reports.