| Panel |
|---|
| panelIconId | atlassian-info |
|---|
| panelIcon | :info: |
|---|
| bgColor | #F4F5F7 |
|---|
|
CCC Data Warehouse Report Server v7.8 Last Update: June 2022 |
...
| Panel |
|---|
| panelIconId | atlassian-notelight_bulb_on |
|---|
| panelIcon | :light_bulb_on: |
|---|
| panelIconText | :notelight_bulb_on: |
|---|
| bgColor | #F4F5F7 |
|---|
|
Note: If you are interested in direct (ODBC/JDBC) access to the CCC Data Warehouse via a site-to-site VPN, please contact your Enabling Services College Relationship Manager (CRM) to initiate the request for this access. |
| Note |
|---|
Access to Canvas Data is currently available only by direct access connection. For information regarding the Canvas DW Direct Connect service, please contact your Enabling Services College Relationship Manager (CRM) to initiate the request for this access. |
...
The CCC Data Warehouse is a structured source of master 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 Jasper ReportsJasperReports, a Java-based open-source reporting tool. Jasper ReportsJasperReports, connected to the CCC Data Warehouse, allows for advanced reporting usage and provides extensive help that you can access from the Help link.
...
| Panel |
|---|
| panelIconId | atlassian-light_bulb_on |
|---|
| panelIcon | :light_bulb_on: |
|---|
| panelIconText | :light_bulb_on: |
|---|
| bgColor | #F4F5F7#FFFFFF |
|---|
|
Suggestion: Although any six-digit TOTP compatible authentication software should work for the Report Server User Account, the tools that we’ve found to be most user friendly are: Chrome Authenticator for desktop use and Google Authenticator for mobile devices. Both are free downloads and both can also be used together. |
| Panel |
|---|
| panelIconId | atlassian-check_mark |
|---|
| panelIcon | :check_mark: |
|---|
| bgColor | #F4F5F7 |
|---|
|
NEXT: Start the “First-Time User Log In” process below to initiate the authentication process and log in. |
...
| Expand |
|---|
| title | Expand 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 PageEnsure you have one of the compatible authenticator apps installed on your desktop or mobile device. Navigate to theData Warehouse Report Server URLlog in page. 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 |
|---|
| panelIconId | atlassian-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 PageThe 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.
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 “Submit” to go to the next page.
| Panel |
|---|
| panelIconId | atlassian-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 CodeOnce 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 CodeOnce 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.
| |
| Panel |
|---|
| panelIconId | atlassian-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. |
|
...
| Panel |
|---|
| panelIconId | atlassian-light_bulb_oninfo |
|---|
| panelIcon | :light_bulb_on: | panelIconText | :light_bulb_oninfo: |
|---|
| bgColor | #F4F5F7 |
|---|
|
The scope of this section provides details for accessing and running reports, views and dashboards related to CCC Data Warehouse data. For the purposes of this User Guide, it is assumed that you are accessing reports based on CCC Data Warehouse data specifically. |
...
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.
...
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.
You can now begin working with your report.
...
| Panel |
|---|
| panelIconId | atlassian-info |
|---|
| panelIcon | :info: |
|---|
| bgColor | #F4F5F7 |
|---|
|
Creating Filters with Relative DatesYou 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. |
...