| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
This guide pertains to is for the Data Warehouse Report Server for (CCC Data 2.2.0 - ) released to production on January 527, 2023. |
In This User Guide
| Table of Contents | ||||
|---|---|---|---|---|
|
...
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.
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
College & District SSO Users: See Appendix A: Data Warehouse Report Server URLsfor your custom IdP URL. |
Set Up & Log In Processes
...
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.
The account has been configured with the appropriate roles, attributes, and - for SSO Users only - their institution’s IDP link.
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.
Non-SSO Users have received their account credentials and temporary password from CCCTC Administrator, have installed the authentication app software, and have completed the “First-Time User Log In” process (setup and verification tasks) required to facilitate two-factor authentication at the generic DWRS URL.
...
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.
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Click here for college and district Data Warehouse Report Server URLs. |
...
Part 3: Using the Report Server
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
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 Guideuser 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 | ||||||
|---|---|---|---|---|---|---|
| ||||||
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:
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. |
...