| Info |
|---|
CCC Data Warehouse Report Server v7.8 Last Update: May 2021 |
...
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.
To Install the Chrome Authenticator:
...
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.
...
| Info |
|---|
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. |
...
Contact College Support to report technical issues with the Data Warehouse Report Server - or visit our online community support site, CCCTechnology.info.
...
Part 5: Report Server Report Templates
The Data Warehouse Report Server is a structured source of master data that can be used to generate the reports, templates, data marts, and analytics that end-users need.
The template reports in the Data Warehouse Report Server repository include the following kinds of reports along with their report Views:
ready-to-use standard reports specific to single application data instances
ready-to-use CCC Data Warehouse reports specific to one of the following application data sources:
Canvas
CCCApply Standard application
CCCApply International application
California College Promise Grant application
MyPath
Report Overviews:
DW LGBTQ Report
...
DW LGBTQ Report
The Data Warehouse (DW) LGBTQ Report is a ready-to-use report produced from the sensitive CCCApply data available only in the CCC Data Warehouse.
This guide serves as both an overview and a "quick start" guide specifically for accessing and customizing the DW LGBTQ Report template.
You can:
run the preconfigured LGBTQ report that pulls CCCApply data from the CCC Data Warehouse
create a custom LGBTQ report "View" from which you can customize the LGBTQ report data
Running the DW LGBTQ Report
Use the following steps to access and run the DW LGBTQ Report once you are logged in to the Data Warehouse Report Server.
Click View → Repository to display the repository Folders in the 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, including the DW_LGBTQ_Report.
Click the DW_LGBTQ_Report link to run the report.
| Tip |
|---|
For detailed information on getting to the Data Warehouse Report Server and your authorized login credentials, see Getting to the Report Server in this user guide. |
screen shot of report
| Note |
|---|
Due to the sensitive nature of the LGBTQ report details the data has been obfuscated in the image above. |
Using the Input Controls
4. If you want to narrow the report's results to a different time range from the default, click the Options icon to display the Input Controls dialog box and enter date/time fields to specify a new date range.
screen shot
5. Click Apply to apply the new date range. The report will run and display results within the new date/time range you specified. The Input Controls dialog box continues to display allowing you to change the values if needed.
The table below outlines the available actions you can 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 | 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; screen shot 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). screenshot |
6. You can save the report by clicking the Save/Save As... icon:
screenshot
And then export the report into a variety of file formats.
screenshot
Click the… | To… |
|---|---|
Save icon and select Save | save the report to your college or district default 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: screenshot |
Export icon | select an export format that auto-downloads to your computer's hard drive default download location |
7. After running and/or exporting the LGBTQ report, click View → Repository to return to the repository to view the list of reports.